I don't think it's safe to use "select *" in a insert statement.

Try this instead:

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. :)
>
>>Maybe trigger is disabled with

>>ALTER TABLE...DISABLE TRIGGER

?
>>
>>>This is it.
>>>
>>>

>>>CREATE TRIGGER [QPRCopy] ON dbo.QPR
>>>FOR INSERT, UPDATE
>>>AS
>>>
>>>BEGIN
>>>	INSERT INTO QPRAudit
>>>	SELECT * FROM Inserted
>>>END
>>>