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;
Log
Event log
While connected to a database and using master
SELECT * FROM sys.event_log;
Last hour events
SELECT * FROM sys.event_log WHERE start_time>DateAdd(HOUR, -1, CONVERT(datetime2,SYSDATETIME()));
Not connection succeed events
SELECT * FROM sys.event_log WHERE event_subtype_desc <> 'connection_successful';
dba/mssql/mssql_basic_queries.1692030680.txt.gz · Last modified: 2023/08/14 16:31 by dodger