VB and VBA Users Source Code: Counting the number of SQL logins for a user

VB/VBA Source Code
Counting the number of SQL logins for a user

By:	Andrew Baker
Email (spam proof):	Email the originator of this post
Date:	Thursday, October 09, 2003
Hits:	1050
Category:	Database/SQL/ADO

Article:
The SQL below returns the login ids and a count of the number of connections open open. select name, count(name) from master..sysprocesses sp, master..syslogins sl where sp.sid = sl.sid group by name order by name This can be used to prevent multiple logins.
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder