View Single Post
 
Old November 10th, 2004, 07:58 AM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Arsi,

Yes, you could write a trigger on the table on which you run the update statement, so that on update event happening on that table would trigger another update event that updates the values to the other table on another database. It could be something like this.
Code:
CREATE TRIGGER [MyTrig] ON [TABLE1] 
FOR UPDATE
AS
If update(COLUMN1)
    Update OTHERDB..TABLE1 set COLUMN1 = i.COLUMN1
        from DELETED d, OTHERDB..TABLE1 t, INSERTED i
        where d.COLUMN1 = t.COLUMN1
return
Hope this gives you the needed push you in the right direction.;)
Cheers!

_________________________
- Vijay G
Strive for Perfection