[AccessD] Users in SQL Server

Lonnie Johnson prodevmg at yahoo.com
Mon Apr 2 06:51:40 CDT 2007


You can do a passthrough query to the master database and execute this system stored procedure. 

EXEC SP_WHO
 
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us




 



----- Original Message ----
From: JWColby <jwcolby at colbyconsulting.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>; dba-sqlserver at databaseadvisors.com
Sent: Monday, April 2, 2007 6:31:59 AM
Subject: [AccessD] 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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


 
____________________________________________________________________________________
We won't tell. Get more on shows you hate to love 
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265 


More information about the AccessD mailing list