Finding Login Counts and Creation Dates

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..sysloginsGO

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..sysloginsGO

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 GOSELECT COUNT(*) FROM sysusersSELECT name, createdate FROM sysusersGO

These queries should give you the login and user information you need.

• ITPro Today's 2025 IT Priorities Report

  Aug 8, 2025

• Edge Computing Trends: Adoption, Challenges, and Future Outlook

  Jul 15, 2025

• ITPro Today’s 2024 State of DevOps Report

  Dec 16, 2024

• BCDR Basics: A Quick Reference Guide for Business Continuity & Disaster Recovery

  Oct 10, 2024