How to void timeout error? - SQL Server Forums

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."

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

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."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources