stored procedure exits in the middle of the execution  
Author Message
Sati





PostPosted: Top

SQL Server >> stored procedure exits in the middle of the execution

i have created stored procedure to call another stored procedre on a
linked server, but if the linked server is not accessable for a
certain reason the procedure breaks down and it will not continue to
excute the next statments that will handle the error as shown in the
below code



procedure










else
print 'password have been changeed successfully for login ID:


SQL Server236