Re: tables droped by whom?

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 21:19:11 +0530

Hi,

SQL Server will not audit any activities by default. To get this information
you should enable the c2 audit or
you should run the profiler all the time.

Thanks
Hari
MCDBA

"Yvette" <Yvette@discussions.microsoft.com> wrote in message
news:692671D2-231C-49F3-9119-837A8F239DDF@microsoft.com...
> Someone has dropped some tables on the database - I need to find out by
whom
> and what application was used (if possable)

Relevant Pages

  • Re: Whats wrong with triggers?
    ... Triggers are a detailed and legal under SOX method of auditing the data ... going in/being changed in your database, for a complete audit trail you ... there are flags that actually stop the SQL Server if the trace ... > database and the auditing system, ...
    (comp.databases)
  • Re: One Web Service updates SQL, another cant?
    ... In the profiler, in the Events tab, click on Security Audit. ... Columnist, SQL Server Professional ... And then I start getting the database closed errors on subsequent calls. ... >>> thing to look at is the permissions for that user in EM. ...
    (microsoft.public.sqlserver.security)
  • Re: flexible back-end data handling in .net + sql project
    ... right indexes in place will very important but there's no reason to ... The database is surely the best place for your audit trail because ... SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: file backup component
    ... Otherwise you can try to use audit techniques to find out who's trying to access the LDF file. ... file backup app or any other app that need LDF file a while. ... he meant something that belongs to the SQL server itself. ... Delay the start of the SQL server service until manual start. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Audit logging an adp
    ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)