connection timeout error while checking mediastream available or not

Question

In My Console application. i am checking media links which is available in my database through openstream.but one error is raising again and again in diffrent diffrent point.that is "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated"

Answer 1

These 2 similar problems/solutions might give you some ideas. One was fragmented table and the other was a lock by another db operation.

http://forums.asp.net/t/1513085.aspx/1/10

SQL Server simple Insert statement times out