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 - 2006-01-23 : 07:59:15
|
| donald writes "Hi allIs it possiable to use an on insert trigger to insert the same record into another server (linked)? I have the link set up but have not often written trigers Any hints or issues with this would be appreciated.thanks" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-24 : 00:51:34
|
From BOLA trigger is created only in the current database; however, a trigger can reference objects outside the current database. I am not sure if it can reference linked Server. So try it and see  MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
using triggers and a linked server