View Single Post
 
Old November 10th, 2004, 01:34 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

Hi!

Thank you for your help! This is what I came up with, with your help. It does not update the second database though. What am I doing wrong?

ALTER TRIGGER [Update_DB] ON [dbo].[ProjectInfo]
FOR UPDATE
AS
If UPDATE(ProjectName)
    UPDATE ProjectStatus..ProjectInfo2
    SET ProjectName = i.ProjectName
    FROM ProjectInfo d, ProjectStatus..ProjectInfo t, ProjectInfo2 i
    WHERE d.ProjectName = t.ProjectName
RETURN

*******(*)*******