I m facing a problem of timeout expired.If I execute stored procedure through Asp Page, which returns approximately 200000 rows, my ASP page always gives error “Script time out” after 40 Seconds. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E31) [Microsoft][ODBC SQL Server Driver]Timeout expired But if I insert the required rows into a table […]
2004-10-07
13 reads
I would try and re-install the application and then uninstall. Looks like somehow the file required to uninstall was deleted
2004-09-29
You've been asked this in an interview for a DBA position I would assume? If that assumption is not true, please ignore the rest of this message. If it's true:1. You need to go spend some money on SQL Server books and begin reading. Don't stop until you have read at least 20 of them […]
2004-07-08
Great!! Thank you all. I think we figure out at the same time you guys were responding. Thank you anyway. I run it with the @@error for each statement in the sp and it seems to work. The developers will run it tonight the the big job they designed and hopefully it will work. Thank […]
2004-04-07
Hi, sorry about that. i assumed that everyone would be able to see the print screen. Here is the text from the error box:Line: 307 Char: 2 Error: Unexpected error Code: 0 URL: res//C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.htm Do you want to continue running scrips on this page?
2004-04-06
thanx a lot .i have modified some types using this method , but , when the types are used in a stored procedure what to do ? sp_droptype is not allowing me to drop it ..
2004-04-06
I have done some searching in the BOL looking for a way to check the existence of a table in TEMPDB. No luck.I am looking to check the existence a table in the TEMPDB. The table is called #TEMP_WORK. I want to check if it is there before using a create table statement.I am running […]
2004-04-06
I would guess that when SP4 was applied you would need to update the statistics. Have you checked the query plan?
2004-04-06
Dear All,I have an IP Phone in my office configured on a public Ip address. I would like to dial to this IP using some Software from a PC. Is there any software which does this. A search on google confuses me.Levi
2004-04-01
put a clustering index on it and use rebuild index or indexdefrag also take a look at pad_index and fillfactor
2004-04-01
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers