SQLServerCentral.com / Discuss content posted by Eric Wahner / Article Discussions / Article Discussions by Author / What&#39;s Running / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 15:58:39 GMT20RE: What&#39;s Runninghttp://www.sqlservercentral.com/Forums/Topic401519-465-1.aspxHi 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,nullI tried this in 08 R2. Let me know if I went correctly or not. Thank youTue, 27 Dec 2011 20:32:34 GMTDBA_LearnerWhat&#39;s Runninghttp://www.sqlservercentral.com/Forums/Topic401519-465-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Lock+and+Connection+Management/31900/">What&#39;s Running</A>[/B]Sun, 23 Sep 2007 02:26:47 GMTEric Wahner-345205