NotMe Asked: 2010-09-30 06:10:50 +0800 CST2010-09-30 06:10:50 +0800 CST 2010-09-30 06:10:50 +0800 CST Is there any way to see who deleted a view? 772 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? sql-server-2008 2 Answers Voted Best Answer DaniSQL 2010-09-30T08:31:48+08:002010-09-30T08:31:48+08:00 You can try two things: If you are on SQL Server 2005 and above you can interrogate the default trace to see what happened. You can try querying the cache and see the queries issued(If the query is still in the cache and not flushed out) jl. 2010-09-30T06:49:50+08:002010-09-30T06:49:50+08:00 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.
You can try two things:
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.