Unanswered: Error handling in MSSQL - if error during call remote stored prcedure I need SQL code
I want to catch the next MSSQL error in my SQL code with following continue calculations
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
If REMOTE_SERVER_1 is inaccessible (as in (a) below) the executing of SQL will not continue with (b) - I need the code in (b) to run despite whether the previous exec was successful or not - Any ideas?