how to insert/update 7 different databases at the same time ?

i am using store procedure for my all the inserts and updates. Now based some condition i need to insert /update the details in the 7 different dabases. I have tried in the same store procedurte put its taking time and some time it is not inserted/updated properly in the all the 7 databses. Please provide me the solution for achive the task ...
VarshiniAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you explain the scenario a bit having 7 databases?
you might either check to use replication, or linked server in either direction to view/replicate data ...
0
 
HainKurtSr. System AnalystCommented:
one sp in master db, 6 dblinks on others
call sp @ master, it will insert into master table and 6 tables on dblinks...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.