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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Trigger on LinkServer table

Author  Topic 

miranwar
Posting Yak Master

125 Posts

Posted - 2004-07-09 : 05:46:18
Hello,

Can anyone tell me before I try it out. Are we allowed to create a trigger on a Link Server Table ?

So when a particular value is updated in a table on server A it fires a trigger and updates a row in server B.

Both servers A nd B have been linked using the sp_addlinkedserver SP

Many thanks in Advance

Cheers


sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2004-07-09 : 05:49:36
It works.

regards
Sachin
Go to Top of Page
   

- Advertisement -