Error handling - On Error resume next

Error handling - On Error resume next

Post by Henk Huisma » Tue, 21 Nov 2000 04:00:00


I writing a stored procedure to search in more than one database (Linked
servers). I query each database and store the results in a temporary table. After
search through all databases I order the results and return them. However, when
one server is down I still want to return the other results. So what I am looking
for is a kind of "On Error resume next" on T-SQL, can anyone tell me whether this
exists or not?