Thank you. That did the job! :)


>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
>>>>