All Forums UDA
marcmc 112 posts Joined 12/05
02 Jul 2007
Begin Transaction / End Transaction

Can anyone answer this one....I have a procedure that is running inside a BT/ET transaction.However it failed for no apparent reason yesterday. When i remove the BT ET at the beginning and end it runs perfectly but when i comment the BT ET back in it fails again....sometimes. It's intermittant!I've reproduced it but it doesn't make sense. A restore has been running but I cannot blame it on that.I can see it inside the transaction from performance monitor but my thinking is that if it comes out of the transaction at all then it should complete as there is nothing really after the ET.Any ideas why this might happen?

joedsilva 505 posts Joined 07/05
02 Jul 2007

May be there's something like a DDL or so inside the proc ... :owhich is fine if you are just calling the proc, if you enclose the call in an BT/ET it could fail.Or may be you can paste the code & error message.

You must sign in to leave a comment.