When I ALTER PROCEDURE i get the error "A transport-level error has occurred when sending the request to the server.."
user552 Published in May 23, 2018, 6:36 pm
My stored procedure works just fine if I right click and execute
but if I right click and modify then execute I get this 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
Furthermore, when I run the query by itself it works fine too.
I need to modify this SP so I'm not sure what to do