Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Daniel_Buchholz
Starting Member
28 Posts |
 Posted - 2002-05-06 : 08:49:05
|
| Hey all!I have this problem here that I need to check for linked server connectivity to several servers during a long running batch. And the problem is: I cannot afford the batch to crash.Finding out if a linked server exists is very easy. But every time I try to check for the connectivity to a non-existing or currently unavailable server (by just selecting something) my test procedure just exits with an error message (#6).Is there no method for me to react in code?Daniel |
|
|
Daniel_Buchholz
Starting Member
28 Posts |
Posted - 2002-05-07 : 05:45:14
|
| Solved!Seems as it has to be SQL-DMO once again. With SQL-DMO I can catch errors if a linked server is not available.Daniel |
 |
|
|
|
|
|
need to check for linked server connectivity