Msg 10054, Level 20, State 0, Line 0 Error when altering a stored procedure to add a couple of curso

Posted by doug_w on Server Fault See other posts from Server Fault or by doug_w
Published on 2010-04-27T16:48:27Z Indexed on 2010/04/27 16:53 UTC
Read the original article Hit count: 330

We have a home-rolled backup stored procedure that uses xp_cmdshell to create and clean up database backups. We have an instance that is 2005 sp3 that we are trying to deploy this script to. I am at a bit of a loss for why it is not working. When I execute the create it runs for about 30 seconds and yields the following error:

Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: 
TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

In my tinkering I discovered that by removing the cursors that actually do the work it will allow me to create the stored procedure (not very helpful for me though). If I add the cursors back in using an alter the error returns. I would be curious if someone has experienced this problem and knows of a solution or work around. I am not opposed to posting the source, it is just lengthy.

Things I have checked:

  1. Error Logs
  2. No dump files in the log directory

Thanks in advance for the help.

© Server Fault or respective owner

Related posts about tsql

Related posts about transact-sql