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 - 2001-07-18 : 08:14:13
|
| Hendra writes "We plan to use database trigger to insert and update tables in a linked server. Since the linked server is just a standby server, we don't want it to cause a problem to the live server when the linked server not available (no network connection, sqlserver service not running, etc.), if this happen, we will just dump the transaction to a text file to be imported later to make it sync with the live database. How can we achieve this, especially for checking the availability of the linked server without affecting the live server. Thanks in advance." |
|
|
|
|
|
Checking connection to linked server for use in trigger