August 23, 2011 at 6:33 am
I'm not sure I understand the question.
Are you saying that you want to transmit a record, or records, to the other server, but only when a certain action is taken on the first server? I would build that into the procedure that does the action on the first server. You could look at linked servers. Triggers are also a possibility, again through linked servers. You could have two calls from the application. You might look into an extended transaction manager such as BizTalk to put the data into both locations. In short, you have a lot of options. It's unclear to me which might be better based on the question.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply