Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBA Tools:sp_whoio Expand / Collapse
Author
Message
Posted Thursday, April 1, 2010 7:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 24, 2014 6:03 PM
Points: 6, Visits: 227
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
Posted Tuesday, April 6, 2010 10:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 7, 2014 9:51 PM
Points: 1, Visits: 42
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
Posted Tuesday, April 6, 2010 10:10 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:07 AM
Points: 18,060, Visits: 16,094
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
Post #898124
Posted Tuesday, April 6, 2010 11:29 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:07 AM
Points: 18,060, Visits: 16,094
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
Post #898163
Posted Tuesday, April 6, 2010 11:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 24, 2014 6:03 PM
Points: 6, Visits: 227
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
Posted Monday, April 12, 2010 11:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 8:14 AM
Points: 134, Visits: 165
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 »

Add to briefcase

Permissions Expand / Collapse