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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-08-12 : 21:21:10
|
| This is kind of tricky.I have a table in a database and when an inserts happens to that table it invokes a trigger which updates another table in the same database.that part is fine.Is there any way I can transfer data from the updated table to another table in a different server(basically after trigger happens it should pump the data from this table to the other like a DTS execution automatically) |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-12 : 21:24:04
|
| Perhaps you could do this using Linked Servers? |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-08-12 : 21:28:16
|
| but to enable the DTS u don't need to configure linked servers right |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-12 : 21:30:07
|
| Why would you want to do this via DTS? I think the performance would be woefull. If you're only copying over one row at a time then Linked Servers would probably be better. |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-08-13 : 11:13:22
|
| I have heard a lot that linked server performance is not that great |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-08-13 : 11:14:22
|
| I have heard a lot that linked server performance is not that great.Is that true.can I execute a stored procedure in that case within a trigger |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-15 : 08:08:21
|
| You could call an SProc on the remote server to do the insert - that might perform better.But ... looks like you need to perform a TEST!Kristen |
|
|
|
|
|
|
tricky update trigger