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: