Home Forums SQL Server 2005 SQL Server 2005 General Discussion sp_who2 RE: sp_who2
denise.crabtree
SSC Veteran
Points: 213
More actions
June 12, 2008 at 4:15 pm
#828166
The following dm views also need "View Server State" to function
sys.dm_exec_sessions
sys.dm_exec_requests
sys.dm_exec_connections
Therefore these cannot be substituted for sp_who2 which also needs the same permission