Just Learned - Orphaned Distributed Transactions have a SPID = -2

Getting Started with Adobe After Effects - Part 6: Motion Blur

A collection of quick technology learning tips from what people around you learn every day

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

Orphaned Distributed Transactions have a SPID = -2

Jun 20 2011 4:00AM by Nakul Vachhrajani

Just learned that Orphaned, Distributed Transactions have a SPID = -2.

More reference material is availble at: http://msdn.microsoft.com/en-us/library/ms173730%28v=SQL.105%29.aspx Refer example: "C"

Read More.. [6 clicks]

Published under: SQL Server Tips · · · ·

Previous: Deprecated feature 'Table hint without WITH' is not supported in this version of SQL Server. - SQL Azure
Next: Filegroups table dependencies

Nakul Vachhrajani

4 · 33% · 10585

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it

Nice tip Nakul. Thanks for sharing...

commented on Jul 13 2011 10:59PM

Hardik Doshi

20 · 9% · 2839

Sign Up or Login to post a comment.