1. BikeBoy New Member

   Hi,
   
   Can someone remind me what's the DMV that replaces sp_who in sql 2005? Supposed to be able to pass the database name to see spids on specific database.
   I though it was dm_exec_connections, but there's no database param option.
   
   Thanks

   BikeBoy, Jan 20, 2006

   #2
2. satya Moderator

   I don't see any replacement to SP_who in SQL 2005, but there are few DMVs added to get more information.
   
   Let me see whether we can get more information about what you're after.
   
   Satya SKJ
   Contributing Editor & Forums Moderator
   http://www.SQL-Server-Performance.Com
   This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

   satya, Jan 23, 2006

   #2
3. BikeBoy New Member

   Here's how to do it:
   
   
   select * from sys.dm_exec_requests
   where database_id = db_id ('master')

   BikeBoy, Jan 24, 2006

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in