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 |
|
GregDave
Starting Member
2 Posts |
 Posted - 2008-05-01 : 11:40:44
|
| Hello All,This is my first time posting here so thanks for you assistance in advance.I have a project I am working on where I need to use database triggers to upon update update a table on another SQL server. Below is how it would work.Server A (SQL 2000)Table A is updated (execute trigger to update Server B, Table B)Server B (SQL 2005)Table B (Tabled updated by SQL 2000, server).I don't know if this can be done using the SQL server technology itself or how I would do it. Is a .NET or other program service have to be used in this scenario? Your help is appreciated.Thanks,Davy |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-05-01 : 11:54:51
|
| Do NOT write a trigger to transfer data.Use replication instead, or at least write your trigger to populate a staging table rather than send data directly to the other server.The scope of a trigger should be limited to its table if possible, and never beyond its database.e4 d5 xd5 Nf6 |
 |
|
|
GregDave
Starting Member
2 Posts |
Posted - 2008-05-01 : 14:02:43
|
| Thanks for the reply! Looks like I was on the wrong track. I thought there might be a better way.Thanks,Davy |
|
|
|
|
|
|
Trigger Update Between Servers