Post reply

SP_WHO3 for SQL 2005

  • February 28, 2008 at 12:03 pm

    #154162

    Is there an sp_who3 for sql server 2005? I thought I found out online a while back but cannot find it now.

    ¤ §unshine ¤

  • February 28, 2008 at 12:15 pm

    #783400

    This is a little something I've been working on ... you might find it handy. It is not yet finished, but it does the job.

    One is a proc that uses DBCC INPUTBUFFER, the other is a view which utilizes the DMV's as an alternative to DBCC INPUTBUFFER. Long story short, there is a bit of a difference between the two from time to time in terms of seeing the object being run (DBCC) vs. the definition of the object (DMV's).

    Hope it helps.

  • February 28, 2008 at 12:24 pm

    #783404

    Awesome!I'll try it out... thank you!

    ¤ §unshine ¤

  • February 28, 2008 at 1:03 pm

    #783425

    It looks like the proc fixed itself transferring from 2000 to 2005. This is the script output.

    ¤ §unshine ¤

Viewing 4 posts - 1 through 3 (of 3 total)

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