Post reply

DBA Tools:sp_whoio

  • April 1, 2010 at 7:22 pm

    #386631

    Comments posted to this topic are about the item DBA Tools: sp_whoIO[/url]

    Hi All,

    Just a note to let you know that the issue with the TAB characters has been resolved, so you can just copy and paste the script if you would like to use it.

    Thanks

  • April 6, 2010 at 10:03 pm

    #1146985

    Hi,

    Iam getting syntax errors while testing the syntax for the procedure sp_whoio..

    Can you please suggest on this ? Iam using sqlserver 2005.. Infact the output of this sp_whoio is extreemly useful for production environment issues..

    Thanks in advance.

    Regards

    CVN Rao

  • April 6, 2010 at 10:10 pm

    #1146992

    cvn Rao (4/6/2010)

    Hi,

    Iam getting syntax errors while testing the syntax for the procedure sp_whoio..

    Can you please suggest on this ? Iam using sqlserver 2005.. Infact the output of this sp_whoio is extreemly useful for production environment issues..

    Thanks in advance.

    Regards

    CVN Rao

    There are invisible characters in the code. You will need to remove those non-printing characters and then try the code again.

    You might try notepad++ or even word (paste to word and then to SSMS from word).

    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

  • April 6, 2010 at 11:29 pm

    #1147025

    BTW, I like the idea driving this script. Nice job.

    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

  • April 6, 2010 at 11:36 pm

    #1147030

    Hi,

    The TAB characters in the original script appear as a series of four question marks in the online version. I have asked SQL Server Central for advice and this will be corrected shortly.

    If you copy the script in Notepad, you will find this: ????

    Thanks

  • April 12, 2010 at 11:27 am

    #1150202

    Thank you for posting this, Mircea. I needed something that is quick and easy to run. I appreciate it!

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

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