View Single Post
 
Old November 9th, 2004, 06:26 PM
Arsi Arsi is offline
Authorized User
Points: 457, Level: 7
Points: 457, Level: 7 Points: 457, Level: 7 Points: 457, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2004
Location: Burbank, CA, USA.
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Arsi
Default Update two databases at the same time

Hi!

I need a push in the right direction. I am trying to figure out how to update two different sql server databases at the same time. The databases are both on the same server. Not all the fields in both databases are the same. I want to know should I use triggers or should I just set up an update statement for the both databases and just run those right after each other? Any help with this question is greatly appreciated.

Thanks,

*******(*)*******
__________________
*******(*)*******