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 - 2001-12-07 : 09:30:29
|
| cr8ivity writes "I would like to replicate db1.table1 to db2.table1 so that when new data is added to db1.table1 I can have triggers and stored procedures on db2.table1 that fire. Don't ask why it has to be this way. It is an issue with our accounting software.Anyway, there is so much information regarding replication, linked servers, dts, etc... that I am finding it difficult to figure out what to focus on.I'm fairly competent as far as building queries, triggers and stored procedures but just beginning with SQL administration. Our DBA left us high and dry weeks ago...My question is... do you have an article url or book recommendation for this specific (or close) issue?" |
|
|
PiecesOfEight
Posting Yak Master
200 Posts |
Posted - 2001-12-07 : 13:43:57
|
| I would set up a transactional replication publication that is pushed from db1.table1 to db2.table1. Then add your triggers to db2.table1 and they will fire when data is inserted. What version are you on? I would look in BOL under transactional replication and push subscriptions. |
 |
|
|
|
|
|
Replication Solutions?