microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Drop table

Subject: Drop table
From: "Praetorian Guard"
Date: Fri, 9 Dec 2005 16:05:08 +0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs, microsoft.public.sqlserver.server
Hi NG,

We have a development database and from time to time some user or users will
issue a drop table and I would like to know the user who drop the table.

Is there a way to determine who and when the user issues the drop table DDL
without running the profiler?

If it can't be done without using profiler, how do I filter it by drop table
only if I'm running the profiler?

If you know of any third party software please include it also in your
reply.

Thank you in advance.



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