Orphaned Distribution Transactions

Question

Orphaned Distribution Transactions

Shashank Srivastava

Mr or Mrs. 500

Points: 584
More actions
July 15, 2013 at 10:29 pm

#280169

Comments posted to this topic are about the item Orphaned Distribution Transactions
Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

james.of.rivendell SSC-Addicted Points: 425 More actions · Answer 1

Thanks. This is very useful information. Just on your company's overstrict policy on forums. Forum discussions are an essential tool for DBAs, heck, IT staff in general. It's a necessity. Hope whoever makes these blanket rules comes to their senses.

Shashank Srivastava Mr or Mrs. 500 Points: 584 More actions · Answer 2

I agree. But policy are policy.

Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

Nice article. Thank you for sharing.

I've always used this ref. "Negative Process ID (spid -2) in SQL Server" to guide me through this situation 🙂

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Shashank Srivastava Mr or Mrs. 500 Points: 584 More actions · Answer 4

Thanks for you comments.

Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/

Database admin(DBA) SSCertifiable Points: 5373 More actions · Answer 5

Nice Article and Thank you for sharing this article.

Thanks &regards,

DBA

SQL server DBA

Shashank Srivastava Mr or Mrs. 500 Points: 584 More actions · Answer 6

You are welcome.

Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/

Winston Daley-344648 SSC Enthusiast Points: 138 More actions · Answer 7

Winston Daley-344648

SSC Enthusiast

Points: 138

July 16, 2013 at 8:32 am

#1632890

Thanks, this is one very priceless little gem.

Shashank Srivastava Mr or Mrs. 500 Points: 584 More actions · Answer 8

Thanks for your comments.

Regards
Shashank Srivastava
MCITP - SQL SERVER 2008
INDIA
Follow me @ http://shashanksrivastavasqldba.blogspot.com/

Fonseca SSC Veteran Points: 220 More actions · Answer 9

Great post and I have been doing this for a while, however I haven't looked into the possibility of finding the original transaction. Is there a way to track down which aborted transaction the -2 SPId is?

pragyamishra Newbie Points: 1 More actions · Answer 10

Hi Shashank,

Thanks for the helpful article. Is there any way to also identify which transaction or sql query was associated with this spid/guid? Or any way to identify what caused it to become orphaned?

Thanks.