Viewing 4 posts - 1 through 4 (of 4 total)
I'm sorry, but I haven't had the time to run the script provided by fenwicc yet.
I promise to return with the results, as soon as I am able to perform...
November 1, 2010 at 1:46 am
I finally had time to go back to this issue and had a chance to run the script you suggested. I tried running the script immediately after the transaction failed...
October 20, 2010 at 5:56 am
mferanda (9/29/2010)
Perhaps this is a dumb question, but have you tried:EXEC SP_WHO2
That's not a dumb question at all.
The answer is yes, I have tried to call sp_who2, but...
October 5, 2010 at 3:37 am
GilaMonster (10/19/2009)
Log to a table variable, they're unaffected by rollbacks. Right at the end (after commit/rollback) you can insert the log entries from there into the real table.
That's a really...
October 20, 2009 at 1:16 am
Viewing 4 posts - 1 through 4 (of 4 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy