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 - 2003-11-05 : 07:40:03
|
| Arnold writes "Hi,How to insert data into a table on a different server from a trigger on table which is in the second server? Let me clarify a bit more. I have two SQL servers 'A' and 'B'. I have a table 'Table_A' in a database 'DB_A' in server 'A'. Similary 'Table_B' in 'DB_B' in server 'B'. I have a trigger 'Trig_A' on 'Table_A' for Insert.On insert, I want the inserted record in 'Table_B'. How can I do this?thanks,Arin" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-05 : 12:14:11
|
| Use linked servers in your trigger.Tara |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-11-06 : 02:00:01
|
| Have you catered for restoring one of the databases? Doing the inserts like this won't keep them on step.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Insert data across servers from a Trigger