Just make sure that there are no open transactions left over from previous attempts.

"SELECT @@TRANCOUNT" should return 0 before you attempt to run it again.

Hope that helps, it definitely works...

Your code seems correct, but are you committing or rolling back the transaction before running it a second time?

Remember that if you don't, a new transaction will not be started,...

Thanks Paul, that's exactly what I was looking for...:)

The problem with that solution is that it's very tightly integrated with the logic. It would require changes to the specific application doing the...

Sure, I'll try my best...New example:

Let's say I have an application. Whenever a user updates a row in the [Client] table, 2 things...