spwho2 cleaned up script

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

paultormey Mr or Mrs. 500 Points: 571 More actions · Answer 1

So what's this? Really cleaned up!txtPost_CommentEmoticon(':w00t:');

matt.bowler SSCrazy Points: 2667 More actions · Answer 2

That's pretty cleaned up all right! Does it run on 2012?

ybpriya Grasshopper Points: 11 More actions · Answer 3

cant see nothing, i am using firefox and all it shows is a big textbox for me to type in!!

paultormey Mr or Mrs. 500 Points: 571 More actions · Answer 4

As I said...really cleaned up...has nothing to show!!!

So where's the new script and the example display?

Divine Flame SSCoach Points: 15943 More actions · Answer 5

Please put the script over there. I can see only a text box which is really cleaned up 😀

Sujeet Singh

sagar.gulati Grasshopper Points: 18 More actions · Answer 6

Grasshopper

Points: 18

August 6, 2012 at 5:31 am

Really cleaned up script, nothing to view 😀

jkennedy 33173 Grasshopper Points: 22 More actions · Answer 7

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.

Divine Flame SSCoach Points: 15943 More actions · Answer 8

SSCoach

Points: 15943

August 6, 2012 at 7:53 am

Thanks Kennedy:-).

Sujeet Singh