--------------------------- Microsoft SQL-DMO (ODBC SQLState: 42S22) --------------------------- Error 2714: Invalid column name ' '. --------------------------- OK ---------------------------Here is my tigger code I'm trying to put in.
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