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)