dba:mssql:mssql_basic_queries
This is an old revision of the document!
Table of Contents
MSSQL: Basic queries
Users
All user info
SELECT * FROM sysusers ;
Users with access
SELECT * FROM sysusers WHERE hasdbaccess = 1;
Non mssql internal users
SELECT * FROM sysusers ;
Databases
List databases
SELECT database_id, name, collation_name, user_access, is_read_only FROM sys.databases;
dba/mssql/mssql_basic_queries.1692000909.txt.gz · Last modified: 2023/08/14 08:15 by dodger