if exists (select * from SysObjects where id = Object_id('tblTickets') and type in ('U', 'S') ) begin Drop Table tblTickets end go Create Table tblTickets( TicketID char(36) not null, UserID varchar(50) not null, GeneralCategory varchar(20) not null check( GeneralCategory in ('Hardware', 'Software', 'Network', 'Internet', 'Printing', 'Other') ), SpecificCategory varchar(20) not null, ProblemDescription text, SolutionDescription text, Summary varchar(3000), Keywords varchar(1000), UpdateDate smalldatetime, UpdateUserID Varchar(50), Primary Key (TicketID) ) go drop trigger trTicketsUpdated Create Trigger trTicketsUpdated on tblTickets for insert, update AS BEGIN print '--- deleted ---' select TicketID, UserID, UpdateDate from deleted print '--- inserted ---' select TicketID, UserID, UpdateDate from inserted declare @targetID char(36) select @targetID = (SELECT ticketID FROM inserted) update tblTickets set UpdateDate = getdate() where TicketID = @targetID END insert into tblTickets( TicketID, UserID, GeneralCategory, SpecificCategory, UpdateDate ) values( '9', 'James Bond', 'Printing', 'Paper Issues', '1999-01-23' ); go update tblTickets set UserID = 'M' where TicketID = '9' go