查看sqlserver事件日志事件log_96.trc

SELECT * FROM sys.traces WHERE is_default =1
SELECT 
  TE.name AS 事件类型,
  T.TextData,
  T.ApplicationName,
  T.LoginName,
  T.StartTime,
  T.DatabaseName
FROM fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\log_96.trc',DEFAULT) T
LEFT JOIN sys.trace_events TE ON T.EventClass=TE.trace_event_id
where TextData is not null;

查看sqlserver事件日志事件log_96.trc