I have many remote SQL Servers that I need to check for successful backups. I have created Linked Servers to all of them. I have a stored procedure that runs and checks the MSDB.dbo.sysjobhistory for successful back ups. My problem is if one of those server is turned off or I have a connectivity problem to one of the the stored procedure halts and it does not continue. I get the following "Could not find server '10.1.1.40' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.........". If one of the servers is turned off I would like to at least know the results of the other ones. How can I capture the fact that one of the servers is not online and continue with stored procedure to capture my results.