Click here to Skip to main content
12,354,763 members (58,425 online)
Rate this:
 
Please Sign up or sign in to vote.
I am using Microsoft SQL Server 2008 R2. In my server there are some Database. Now some body has deleted 2 database of them. Now i want to find him/her.

Is there any system to trace it?

Thanks in advance

Rashed
Posted 14-Oct-12 22:05pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

u can use following query

SELECT DATABASEPROPERTYEX('master', 'Status')
GO

Also please follow following link may it could help..

http://www.mssqltips.com/sqlservertip/1037/system-information-in-sql-server-2000-vs-sql-server-2005/[^]
  Permalink  
Comments
Marcus Kramer 17-Oct-12 17:00pm
   
How does any of this tell him who deleted a database?
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Write click on database...
Reports>Standard Report> Schema Change History
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

Write click on database...Reports>Standard Report> Schema Change History
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 22 Oct 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100