Question about triggers

[pjw001]

I am having a problem with a trigger and would like some advice as to whether I have an error in the trigger or have misunderstood how they work.

The trigger is on table A.

The application first deletes a row from table B and then deletes a row from table A. The deletes are within a single SQL transaction.

When the trigger is processed should the row deleted from table B still be available to the trigger?

From what I can tell from the behaviour of the trigger it would seem that the row deleted from table B is not available, but it could be that I have an error in the trigger.

Many thanks for any help or advice offered.

 

[gmmastros]

No. The row from table b should not be available.

If you show the code for the trigger and the exact error message, we may be able to help.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[pjw001]

Thank you George.

If the row is not available there is probably not much that can be done with the trigger.