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

DB Synchronize

P: 1
Actually i have two databases in one server.This database contains lot of tables.

There is one registration table which was common but placed in both dbs.
If any one insert new row in one db it should effect accordingly in other db also. Here there i need to make insert in registration table among two dbs to "mutual exclusive".

At present i written in triggers in both databases in such a way it will effect the other one. But here i got "deadlock" due to concurrency. If in both dbs same trigger fired i stucked

Please suggest me, how can i perform this.
Jun 19 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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