You're usage of row_number(), modulo and such is impressive, but I

must admit that I found the solution a bit over complex and it was making

my head hurt a...

As the saying goes "There's more than one way to skin a cat".

I too would like to see the declaration of dbo.spLogErrorCommitted. The nice thing about

the ADO approach is it's...

NBSteve,

I'm not exactly sure what you were referring too was a misconception, but my intent

wasn't to explain all the nuances of transaction commits and rollbacks.

I'm familiar with...

Team,

I have an answer for retaining logging errors during a rollback situation.

I have an associated reply to another post that you can read at this link

http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/2ab351c2-00cc-4500-841b-35c3271e040b/.

I use a...