Client Database Access/Opened Status

#1

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

#2

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 (AT) discussions (DOT) microsoft.com> wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Client Database Access/Opened Status

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Client Database Access/Opened Status - 02-07-2007 , 03:32 PM

Re: Client Database Access/Opened Status - 02-07-2007 , 09:13 PM