December 21, 2010 at 9:31 am
Hi,
We have a long running SQL script which has many delete statements that joins tables with millions of records. After executing for several hours, it throws the below error:
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.)
We executed the same script on a different server and did not find the same issue; so we know for sure that there is no problem with the script. I did some research online but did not find any resolution for this issue.
Does anybody know the exact cause of this error???
Any help would be appreciated.
Thank You.
December 21, 2010 at 10:08 am
Thanks for you reply. Yes, the script was being run on the server, which does not leave room for network connectivity issues.
December 21, 2010 at 10:11 am
I only see this error when the server is restarted or someone / something killed my connection.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply