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

What's Running Expand / Collapse
Author
Message
Posted Sunday, September 23, 2007 2:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 15, 2014 6:55 PM
Points: 19, Visits: 53
Comments posted to this topic are about the item What's Running
Post #401519
Posted Tuesday, December 27, 2011 8:32 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, October 20, 2014 12:57 PM
Points: 182, Visits: 423
Hi Eric,

This SP is really good. Thanks for it. But, what I noticed is it works only for single user. As you mentioned exec master..spWhatsRunning 0 will not produce any output. It requires usename too.

So, the better way I found is to enter the following way:

exec master..spWhatsRunning 0,Administrator,null

I tried this in 08 R2.

Let me know if I went correctly or not. Thank you
Post #1227169
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse