How can I find out how many logins are in a SQL Server database and when they were created?
Here are several queries that return information about logins on your SQL Server. To find the count of logins on your SQL Server, you can execute the following query:
SELECT COUNT(*) FROM master..syslogins GO
You can execute the next query to get a list of logins on your server as well as the creation date of each login:
SELECT name, createdate FROM master..syslogins GO
Similarly, you can execute the following queries in a database to find the count of users for that database, a list of the user names, and the dates the users were created:
USE <your_database_name> GO SELECT COUNT(*) FROM sysusers SELECT name, createdate FROM sysusers GO
These queries should give you the login and user information you need.