The semaphore timeout period has expired
Posted By: Posted Date: October 06, 2010
Points: 0 Category :Sql Server
For the past few days something weird is happening to our sql server box.ÃÂ During running some procedures we get the following error message:
Msg 121, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)
It seems to happen when running large procedures or even small queries, the session where i run the query get disconnected but I can reconnect right away but it may happen again couple minutes later.
ÃÂ I'm connecting to my Windows server 2003 using remote desktop and running procedures from the SQL Server installed on the Windows Server.
Anybody has an answer?ÃÂ Thanks.
View Complete Post
More Related Resource Links