July 25, 2012 at 3:56 pm
Comments posted to this topic are about the item spwho2 cleaned up script
August 5, 2012 at 9:35 pm
So what's this? Really cleaned up!txtPost_CommentEmoticon(':w00t:');
August 5, 2012 at 10:01 pm
That's pretty cleaned up all right! Does it run on 2012?
August 5, 2012 at 11:25 pm
cant see nothing, i am using firefox and all it shows is a big textbox for me to type in!!
August 5, 2012 at 11:48 pm
As I said...really cleaned up...has nothing to show!!!
So where's the new script and the example display?
August 6, 2012 at 1:32 am
Please put the script over there. I can see only a text box which is really cleaned up 😀
August 6, 2012 at 5:31 am
Really cleaned up script, nothing to view 😀
August 6, 2012 at 6:25 am
Well, it was there a few days ago... Here's the script:
DECLARE @ErrorTable TABLE(SPID INT, STATUS nvarchar(30), LOGIN nvarchar(50), HOSTNAME nvarchar(50), BLKBY nvarchar(10), DBName nvarchar(100),
COMMAND nvarchar(100), CPUTIME INT, DISKIO INT, LASTBATCH nvarchar(100), PROGRAMNAME nvarchar(100), SPID2 INT, REQUESTID INT)
INSERT INTO @ErrorTable (SPID, STATUS, LOGIN, HOSTNAME, BLKBY, DBName, COMMAND, CPUTIME,
DISKIO, LASTBATCH, PROGRAMNAME, SPID2, REQUESTID)
EXEC sp_who2
SELECT * FROM @ErrorTable WHERE STATUS NOT IN ('BACKGROUND','sleeping') AND SPID <> @@SPID
Simply removes the Background and Sleepings records from the view. This allows me to track my active SPIDs a little easier.
August 6, 2012 at 7:53 am
Thanks Kennedy:-).
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply