Re: How to know who deleted a table?

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 01/15/04


Date: Thu, 15 Jan 2004 14:37:53 -0500

Try Lumigent's Log Explorer:

www.lumigent.com

--
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Mike" <npei72@yahoo.com> wrote in message
news:acead494.0401151057.76a339f0@posting.google.com...
Hi All,
I got an emergency problem! A table was deleted by someone, but I
don't know who did this. How can I know it in SQL Server 2000?
Thanks in advance!
Nate


Relevant Pages

  • Re: HasChanges returns false for one row, true when more than one
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... "Mike G Burton" wrote in message ... dataset has a single row, but True if the dataset has multiple rows. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: simple collaboration enable ?
    ... Listen to Mike, ignore the monkey trying to figure ... > throttling on more than 5 concurrent connections). ... > c) not restricted to WSS databases only ... > SQL Server 2K) ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: VS 2005 Beta 1 and SQL Server 2005
    ... Hey Mike ... To use the April CTP of SQL Server 2005 you would have to also use the ... correct build of the .NET Framework which would be the official April CTP. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Database events - notify an application
    ... of sql server was an extended stored procedure. ... Mike ... > You could look at Notification Services: ...
    (microsoft.public.sqlserver.programming)
  • Re: Alex
    ... I believe the XML data type ... If you are to store the data in the database, ... I would agree with Mike that the xml type is the best ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)