Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
That's not me, I swear. – ringø Sep 29 '10 at 14:25
Although I was initially accused. The problem with that was that I wasn't even here. ;) – NotMe Sep 29 '10 at 14:42
What do your logs say? – Chopper3 Sep 29 '10 at 14:48
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 – NotMe Sep 30 '10 at 21:16
For the future you can set up – DaniSQL Oct 1 '10 at 21:04
+1 for how to figure this out in the future – NotMe 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. ;) – NotMe 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


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.