CREATE TRIGGER [QPRCopy] ON dbo.QPR FOR INSERT, UPDATE AS BEGIN INSERT INTO QPRAudit SELECT Field1, field2.... FROM Inserted END>No, I do not have any code like that. This should be fun! Well, maybe not too much fun. :)
>>ALTER TABLE...DISABLE TRIGGER?
>>>CREATE TRIGGER [QPRCopy] ON dbo.QPR >>>FOR INSERT, UPDATE >>>AS >>> >>>BEGIN >>> INSERT INTO QPRAudit >>> SELECT * FROM Inserted >>>END >>>