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 - 2005-03-03 : 07:51:27
|
| Gyno writes "I was wondering if a trigger can be executed across Servers, if not how do you do it across databases within the same server. Here's my problem, I have 2 tables. One contains personnel info, for a application, and the other contains personnel info for another application. I need to keep them seperate, but when a person's name is changed in one app., I need it to change in the other apps. database. I need this to happen within SQL, not within the apps middle tier. Any suggestions are greatly appreciated." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-03 : 08:25:06
|
| A trigger can update data in another server via linked servers and a fully qualified name (svr.db.owner.tbl).But it means if there is a problem with the connection you can't update anything.Better to put the update into a staging table and use a scheduled job to update.==========================================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. |
 |
|
|
|
|
|
Triggers