You should use profiler in this case. In SQL 2005 there are DDL triggers you
For filtering you could filter on Textdata data column with %DROP TABLE% as
a filter. This way you'll see just DROPs of tables and of course you should
include LoginName or DBUserName data columns to see which user issued ta
MCP+I, MCSA, MCSE, MCDBA, MCT
"Praetorian Guard" <[email protected]> wrote in message
> SQL Server 2000
> "Danijel Novak" <[email protected]> wrote in message
> news:[email protected]
>> Which version of SQL are you using?
>> Danijel Novak
>> MCP+I, MCSA, MCSE, MCDBA, MCT
>> "Praetorian Guard" <[email protected]> wrote in message
>> news:e7v%[email protected]
>> > 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.