Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:mssql:mssql_basic_queries

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
dba:mssql:mssql_basic_queries [2023/08/14 16:34] – [Not connection succeed events] dodgerdba:mssql:mssql_basic_queries [2023/08/14 16:35] – [Last hour events] dodger
Line 53: Line 53:
  
 <code sql> <code sql>
-select *  +SELECT 
-from  +    * 
-    sys.event_log  +FROM 
-where start_time>DateAdd(hour, -1, Convert(datetime2,SYSDATETIME()));+    sys.event_log 
 +WHERE 
 +    start_time > DateAdd (HOUR, -1, CONVERT(datetime2, SYSDATETIME ())); 
 </code> </code>
  
dba/mssql/mssql_basic_queries.txt · Last modified: 2023/08/15 08:59 by dodger