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' ORDER BY start_time DESC OFFSET 11 ROWS FETCH NEXT 10 ROWS ONLY;
dba/mssql/mssql_basic_queries.1692030919.txt.gz · Last modified: 2023/08/14 16:35 by dodger