>I've been using sp_who2 working with SQL 2000 to get all connections, now I have a customer running 2005, and sp_who2 seems to only return results based off the current connection, so rather than getting multiple results, I only get one record for the current user connection. Running in in the SSMS as SA I get all records. I've read numerous web links that seem to indicate this is the "new" behavior, but I'm hoping there is a way around this or new call I can make to get all the connections.
>
>Anybody have a workaround on this?
>
>Thanks
>
>Kirk
How about:
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=676&lngWId=5
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
