[Top] [All Lists]

Re: Drop table

Subject: Re: Drop table
From: "David Browne" <davidbaxterbrowne no potted >
Date: Fri, 9 Dec 2005 08:54:37 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs, microsoft.public.sqlserver.server
"Danijel Novak" <[email protected]> wrote in message 
news:[email protected]
> Hi,
> You should use profiler in this case. In SQL 2005 there are DDL triggers 
> you could use.

In 2005 you don't even need DDL triggers.  The lightweight always-on trace 
will catch this, and the "Schema Changes History" report in Management 
Studio will show you who did what.

Now, DDL triggers could be used to capture more details, or actually prevent 
the table from being dropped...


<Prev in Thread] Current Thread [Next in Thread>