wow, mdaniel

you are truely brilliant. That explains it. problem solved.

Obviously something is missing that can't be null, but what.

What a pointless reply.

here is some interesting info from Microsoft:

A trigger operates as if there were an outstanding transaction in effect when the trigger is executed. This is true whether the statement firing...

Here is a gutted version of my trigger.

CREATE TRIGGER [dbo].[tr_Stage]

ON [dbo].[Stage]

FOR INSERT

AS

DECLARE @Row_Count int

SET @Row_Count = @@ROWCOUNT

IF (@ROW_COUNT >= 1)

BEGIN

--Loop through the inserted records to perform...

Well, it turns out that all I need to do is to make the first action of the trigger to be a commit transaction. This is probably a bastardization of...

awesome, that is the answer I was looking for. Do you have a savepoint example that might work for saving the insert and rolling back the trigger related stuff. It...

I am catching the error, which exists in a transaction in the trigger, but it appears that the rollback command is cancelling the entire operation. I am guessing that the...