Client Database Access/Opened Status

Is there a way to tell if a SQL database is currently being accessed by any
clients? Is it possible to see which clients/users are currently accessing a
SQL database?
Thanks,
Scott
You can query sysprocesses, execute sp_who2. On SQL Server
2005, you can query sys.dm_exec_sessions and
sys.dm_exec_connections.
-Sue
On Wed, 7 Feb 2007 13:32:26 -0800, Scott
<Scott@.discussions.microsoft.com> wrote:

>Is there a way to tell if a SQL database is currently being accessed by any
>clients? Is it possible to see which clients/users are currently accessing a
>SQL database?
>Thanks,
>Scott