That's not a gotcha, that's a "Man you wasted valuable development hours to figure that out!"

A few dozen print statements later... It turned out that a where clause was incorrect, but at least I learned how the inserted and deleted tables work during a trigger....

Do stored procedures called by a trigger get syntax checked before execution? In the stored procedure that gets called there is a cursor that queries for the inserted records...

I separated the triggers and there is still no luck. Please help, Scott

The trigger gets fired but it does not execute the stored procedure within the trigger. It only executes the stored procedure when there is an update on the table....

Thanks, I'll post the info on Tuesday.

Scott

For some reason I wasn't able to copy and paste my problem yesterday, so I just reposted today from a different machine, the question is under the title 'Trigger Trouble'.

Scott

The next morning I looked at everything againg and realized that one of my where clauses did not make sense.  Everything worked once I corrected the where clause. 

Thanks for...