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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-29 : 09:39:50
|
Charlotte writes "Hello
We are currently attempting to use Linked Servers in SQL 7.0 and have a question.
We are trying to find a method to test programmatically whether a Linked Server is available (ie the remote database is up and available) before attempting to run a SQL command against it in a Stored Procedure on the local server. Have looked in BOL, but cannot find anything. Does anyone have any ideas?
We have tried the following:
Using sp_linked server status, which doesn't really tell you whether you have a live link or not.
Kind regards
Charlotte" |
|
|
|
|
|
Linked servers-how to check if up and running from sql?