Here is a T-SQL query which gives information on who and when was a database deleted.
SELECT name AS EventName, DatabaseName, StartTime, LoginName FROM sys.traces T CROSS Apply fn_trace_gettable(CASE WHEN CHARINDEX('_', [path]) <> 0 THEN SUBSTRING(PATH, 1, CHARINDEX('_', T.[path]) - 1) + '.trc' ELSE [path] END, max_files) TT JOIN sys.trace_events TE ON TT.EventClass = TE.trace_event_id WHERE name like '%Deleted%' AND ObjectName IS NULL AND EventSubClass = 1 ORDER BY StartTime DESC
1 comment:
For those interested in nursing education, this essay on https://www.nursingpaper.com/examples/discussion-and-critical-analysis-learning-and-teaching-in-the-nursing-setting-essay/ is a must-read. The critical analysis offers deep insights and practical applications that are really helpful.
Post a Comment