>--------------------------- >Microsoft SQL-DMO (ODBC SQLState: 42S22) >--------------------------- >Error 2714: Invalid column name ' '. >--------------------------- >OK >--------------------------- >>
>CREATE TRIGGER [Audit_Update] ON dbo.meetings > FOR UPDATE >AS >declare @tcAction varchar(500) >set @tcAction=" " > >if update(begintime) or update(RoomID) > begin > if update(Begintime) > set @tcAction='Scheduled Time/Date Changed ' > if Update(RoomID) > set @tcAction=@tcAction+'Room Changed' > INSERT INTO meeting_Audit (meetingnumber,begintime,endtime,patientID,roomid,actualRoomID,ScheduledBy,BlockMember,LastAuditForm,LastAuditBy) > (SELECT meetingnumber,begintime,endtime,patientID,roomid,actualRoomID,ScheduledBy,BlockMember,@tcAction,dbo.get_login_name() > from deleted) > end >