dba:mssql:mssql_basic_queries
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
dba:mssql:mssql_basic_queries [2023/08/14 08:04] – dodger | dba:mssql:mssql_basic_queries [2023/08/14 16:35] – [Last hour events] dodger | ||
---|---|---|---|
Line 30: | Line 30: | ||
sysusers | sysusers | ||
; | ; | ||
+ | </ | ||
+ | ===== Databases ===== | ||
+ | ==== List databases ==== | ||
+ | <code sql> | ||
+ | select database_id, | ||
+ | name, | ||
+ | collation_name, | ||
+ | user_access, | ||
+ | is_read_only | ||
+ | from sys.databases; | ||
+ | </ | ||
+ | |||
+ | ===== Log ===== | ||
+ | ==== Event log ==== | ||
+ | While connected to a database and using '' | ||
+ | <code sql> | ||
+ | select * | ||
+ | from sys.event_log; | ||
+ | </ | ||
+ | |||
+ | ==== Last hour events ==== | ||
+ | |||
+ | <code sql> | ||
+ | SELECT | ||
+ | * | ||
+ | FROM | ||
+ | sys.event_log | ||
+ | WHERE | ||
+ | start_time > DateAdd (HOUR, -1, CONVERT(datetime2, | ||
+ | |||
+ | </ | ||
+ | |||
+ | |||
+ | ==== Not connection succeed events ==== | ||
+ | |||
+ | <code sql> | ||
+ | SELECT | ||
+ | * | ||
+ | FROM | ||
+ | sys.event_log | ||
+ | WHERE | ||
+ | event_subtype_desc <> ' | ||
+ | ORDER BY | ||
+ | start_time DESC OFFSET 11 ROWS FETCH NEXT 10 ROWS ONLY; | ||
</ | </ | ||
dba/mssql/mssql_basic_queries.txt · Last modified: 2023/08/15 08:59 by dodger