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:
- Error Logs
- No dump files in the log directory
Thanks in advance for the help.
© Server Fault or respective owner