Re: SQL Server 2000 Audit

From: Andrew J. Kelly (ajkellynospam_at_attbi.com)
Date: 05/28/03 

Date: Wed, 28 May 2003 08:21:46 -0400

You might want to take a look here:
http://www.lumigent.com/downloads/schemaalert/ 

-- 
Andrew J. Kelly
SQL Server MVP
"Poch Reyes" <pochreyes@hotmail.com> wrote in message
news:u3kKt1NJDHA.2232@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Can someone please recommend the best way to audit SQL Server 2000,
atleast
> agaist DDL executions?
> We have just experienced a stored prcedure that we use daily in our
> scheduled job suddenly disapper!
>
> Thanks,
>
> Poch
>
>
>

Relevant Pages

  • Re: Determine Disk Block Size ?
    ... As always, thanks Andrew. ... Most of the documentation for 2000 is wrong in that it may state you need multiple files to spawn multiple threads. ... >> The MS SQL Server Operations Manual makes a recommendation of using 64-KB>> cluster sizes. ... We have done so with a dramatic total disk I/O>> throughput. ...
    (microsoft.public.sqlserver.server)
  • Re: reindex or update stat
    ... update statistics turned on sql server should deal with it appropriately. ... Andrew J. Kelly ... SQL Server MVP ... I set up the Maintenance Plan to have Optimizations to ...
    (microsoft.public.sqlserver.server)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.sqlserver.programming)
  • Re: Profiling error message 208: sorting the wheat from the chaff
    ... Profile load to a file then load the> file to a table or have Proviler load to a table directly. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)