Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to void timeout error?

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2009-08-13 : 12:33:36
How to void timeout error?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-08-13 : 13:02:30
Fix your code, fix your schema, fix the hardware, fix the indexes, update statistics, rebuild the indexes, etc... The list goes on and on.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2009-08-13 : 14:33:47
Set the timeout time higher.






CODO ERGO SUM
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-08-13 : 15:08:46


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -