Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

In SQL 2008, is there any way to see details about a deleted view. In particular who might have done it or at least when?

share|improve this question
1  
That's not me, I swear. –  ring0 Sep 29 '10 at 14:25
    
Although I was initially accused. The problem with that was that I wasn't even here. ;) –  Chris Lively Sep 29 '10 at 14:42
    
What do your logs say? –  Chopper3 Sep 29 '10 at 14:48

2 Answers 2

up vote 1 down vote accepted

You can try two things:

  1. If you are on SQL Server 2005 and above you can interrogate the default trace to see what happened.
  2. You can try querying the cache and see the queries issued(If the query is still in the cache and not flushed out)
share|improve this answer
    
I looked at the tracing information. There wasn't anything in there for the time period. So I widened my search, and the only thing that seems to show up are some backup events –  Chris Lively Sep 30 '10 at 21:16
    
For the future you can set up auditing...msdn.microsoft.com/en-us/library/dd392015(SQL.100).aspx –  DaniSQL Oct 1 '10 at 21:04
    
+1 for how to figure this out in the future –  Chris Lively Oct 18 '10 at 19:05

Not certain, but this might help:

DBCC Log (your_data_basename, parameter) where parameter is 0, 1, 2, 3, or 4.

0 is basic info, 4 is full info.

share|improve this answer
    
I don't think I'm smart enough to read that. ;) –  Chris Lively Sep 30 '10 at 21:17
    
The closest you might be able to get to answer is a list of those who would have sufficient permission to do so. This might be the beginning of a case to limit who is db_owner or in the sysadmin server role, especially if you are the first stop in the hunt. This is also the kind of circumstance where the thinking of those who like to jump to the favorite conclusion is displayed. –  jl. Oct 1 '10 at 13:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.