By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,359 Members | 1,455 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,359 IT Pros & Developers. It's quick & easy.

Trigger -help

P: 17

Now we are trying to synchronize two databases through coding. For that we have created Flags in each table. If we insert a new value to one table, the flag of that table will be NULL. and once the synchronization starts and the same inserted value gets updated into the next database then the flag will automatically Turn to True. While updating a particular row. The flag will turn to FALSE.

But now we want to update the flag through a trigger. How can we update the Flag of a row, if any of the row column gets updated. How can we use a trigger to update the same

Thanking you

Mar 26 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
Try replication

-- CK
Mar 26 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.