>CREATE TRIGGER [QPRCopy] ON dbo.QPR >FOR INSERT, UPDATE >AS > >BEGIN > INSERT INTO QPRAudit > SELECT Field1, field2.... FROM Inserted >END >>
>>>ALTER TABLE...DISABLE TRIGGER?
>>>>CREATE TRIGGER [QPRCopy] ON dbo.QPR >>>>FOR INSERT, UPDATE >>>>AS >>>> >>>>BEGIN >>>> INSERT INTO QPRAudit >>>> SELECT * FROM Inserted >>>>END >>>>