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.
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.