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

Re: Drop table

Subject: Re: Drop table
From: "Praetorian Guard"
Date: Fri, 9 Dec 2005 18:07:05 +0800
Newsgroups: microsoft.public.sqlserver.notificationsvcs, microsoft.public.sqlserver.server
SQL Server 2000

"Danijel Novak" <[email protected]> wrote in message
news:[email protected]
> Hi,
>
> 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.
> >
> >
>
>



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