Identify the user login datails who deleted my database

• Chandru -734144

  Ten Centuries

  Points: 1040

  More actions

  December 11, 2009 at 12:48 am

  #136846

  Hi all,

  I have one quick question and i need your help on this,

  I have database named 'Test' in my local server.Say for example someone has dropped the same.

  How to identify from which login the database have been dropped and the other information like when the database have been dropped i mean date & time?

  Is there any query for this or any log files which holds this information?

  Thanks,

  Chandru

• Chandru -734144

  Ten Centuries

  Points: 1040

  More actions

  December 11, 2009 at 2:25 am

  #1091033

  Hi all,

  I have got a solution by surfing in Sql server central forum discussion .

  Solution:

  SELECT * FROM fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default);

  Is there any other thing to identify the same?

  Hope the above solution may be useful for someone.

  Thanks,

  Chandru