Online Tutorials & Training Materials | STechies.com
Register Login

How to find the User Information who has Dropped a DB?

|| || 1

How to find the User Information who has Dropped a DB?
Stechies

Hello Experts,

May I know that how did you find the user information who has dropped a DB?

Kindly share your views here.

Thanks in advance.


Comments

  • 18 Jan 2016 5:09 pm

    SELECT * INTO #trace_table FROM ::fn_trace_gettable('c:my_trace.trc', default)
    where textdata like 'drop'

    -- Now you can apply filters on this temp table.
    -- Using select * from sys.traces, you can get the trace location and change the location in quotes in above command.
    -- Go to above location physically to know that how many older trace files you have there at that location and their creation timestamps.
    -- In case you want to search previous trace file, you can again use above command by changing location, temp table name and then apply filters to that also for your keywords search.

Related Articles