Re: who dropped my table in SQL Server?

Not necessarily all that easily without knowing when it may
have been dropped. Third party log reading tools can give
you information on schema changes for whatever logs, log
backups you load for the tool to read. Some tools are listed
at:
http://www.aspfaq.com/show.asp?id=2449
Or ff you were running a trace during the time it may have
been dropped....but that's about it on SQL Server 2000.

-Sue

On 23 May 2006 12:53:15 -0700, wenwei.xie@xxxxxxxxx wrote:

Is there a way to find out which user dropped my table in SQL Server
2000 and when? Thanks.

.