Post reply

spid

  • September 7, 2009 at 9:21 am

    #135839

    how to findout the what command excuted by perticular spid?

  • September 7, 2009 at 9:38 am

    #1050157

    charipg (9/7/2009)

    how to findout the what command excuted by perticular spid?

    dbcc inputbuffer(Spid_Number)

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • September 7, 2009 at 9:58 am

    #1050165

    thanks........

    i am not getting complete command from dbcc inputbuffer.

  • September 7, 2009 at 10:20 am

    #1050170

    for example a update command(update table set id=1) excuted by perticular spid,how to get that command.

  • September 7, 2009 at 11:05 am

    #1050179

    dbcc inputbuffer shows only first 256 signs of the query, you can see whole query using following code:

    select t1.session_id, t2.text from sys.dm_exec_requests t1 cross apply sys.dm_exec_sql_text(sql_handle) t2

    where t1.session_id =

  • September 7, 2009 at 12:19 pm

    #1050196

    thanks a lot.............

  • September 7, 2009 at 12:22 pm

    #1050198

    Hi marcin gol,

    can u pls provide the same query for sql2000.

    thanks in advance.

Viewing 7 posts - 1 through 6 (of 6 total)

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