SQL 2005 Timeout Expired `

2018-06-20 03:39:16

I am facing a SQL Timeout Expiration error while executing it through a website . The actual bug shows

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

What i have tried

Goto SQL Server Settings and changed the Execution time from 600 to 0(for unlimited)

Also tried Timeout key on connection string in configuration file

No luck ! Any options to try out

检查你没有在表中应用任何锁，锁定也会产生这样的问题。

You can specify the timeout on the SQL command,

SqlCommand myCmd = new SqlCommand("myStoredProcedure", myConnection);
myCmd.CommandTimeout = 300;

But you really need to be looking at the query and/or your table structure, you shouldn't need to extend the timeout.

链接地址: http://www.djcxy.com/p/56684.html