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