Post reply

SPID

  • June 18, 2011 at 4:07 pm

    #242348

    Comments posted to this topic are about the item SPID

    Thanks

  • June 18, 2011 at 5:49 pm

    #1340834

    Thanks for a rather simply, but clear cut question.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • June 20, 2011 at 2:50 am

    #1341009

    Good question, and easy if one has ever experienced orphaned transactions. Even in the Books-On-Line, this one is hard to find (there's just one reference to the -2 value).

    Overall, a good question to start the week.

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • June 20, 2011 at 3:01 am

    #1341011

    Excellent question. I've never experienced an orphaned distributed transaction so I had to research this one before answering.

  • June 20, 2011 at 3:07 am

    #1341013

    Good question, thanks 🙂

    M&M

  • June 20, 2011 at 5:27 am

    #1341064

    Good question!!!! 🙂

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • June 20, 2011 at 5:33 am

    #1341073

    I learned something new today. Good question.

    http://brittcluff.blogspot.com/

  • June 20, 2011 at 6:58 am

    #1341155

    Well writen easy Monday question. Thank you

  • June 20, 2011 at 7:40 am

    #1341197

    Great question, thanks. Learned something today...

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 20, 2011 at 9:50 am

    #1341287

    A good straight forward question for Monday, thanks.

  • June 20, 2011 at 11:34 am

    #1341344

    good question

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 20, 2011 at 12:26 pm

    #1341382

    Nice question.

  • June 20, 2011 at 4:19 pm

    #1341502

    Nakul Vachhrajani (6/20/2011)

    Good question, and easy if one has ever experienced orphaned transactions. Even in the Books-On-Line, this one is hard to find (there's just one reference to the -2 value).

    Overall, a good question to start the week.

    Yes, it is a good question. But BoL contains more than one reference to the -2 value; it's on the KILL page, the sp_who page, the sp_lock page, the sys.sysprocesses page, and the sys.dm_tran_locks page so that's at least 5 BoL pages that describe it; probably there are more.

    Tom

Viewing 13 posts - 1 through 12 (of 12 total)

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