[dba-SQLServer] Users in SQL Server

Yes, there is.  If you are using SQL Server 2000:

1.  Expand "Management"
2.  Expand "Current Activity"
3.  Click on "Process Info"

Doris Manning
Database Administrator
Hargrove Inc.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Monday, April 02, 2007 7:32 AM
To: 'Access Developers discussion and problem solving';
dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Users in SQL Server

Is there something that can be read from SQL Server to discover the count of
and even a list of users logged in to a SQL Server database?  I am moving a
client from an MDB data store to SQL Server and need to get this information
on demand, using VBA.
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com