DBA Tools:sp

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Mircea Nita » DBA Tools:sp_whoio

DBA Tools:sp_whoio

Rate Topic

Display Mode

Topic Options

Author

Message

Mircea

Posted Thursday, April 01, 2010 7:22 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 1:10 AM
Points: 6, Visits: 122

Comments posted to this topic are about the item DBA Tools: sp_whoIO

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

Post #895430

cvn Rao

Posted Tuesday, April 06, 2010 10:03 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 5:48 AM
Points: 1, Visits: 32

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

Post #898117

SQLRNNR

Posted Tuesday, April 06, 2010 10:10 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

cvn Rao (4/6/2010)

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 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #898124

SQLRNNR

Posted Tuesday, April 06, 2010 11:29 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

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

Post #898163

Mircea

Posted Tuesday, April 06, 2010 11:36 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 1:10 AM
Points: 6, Visits: 122

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

Post #898168

Chadwick-788357

Posted Monday, April 12, 2010 11:27 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 9:29 AM
Points: 134, Visits: 159

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

Post #901797

« Prev Topic | Next Topic »

Permissions