Auditing DDL and schema changes in SQL Server 2000

Rather than reinvent the wheel, I was hoping that there was someone who has
already created a script allowing for the auditing of DDL statements, schema
changes within the database for SQL Server 2000.
I can easily capture the aforementioned in SQL 2005 by making use of a
trigger on
DDL_DATABASE_LEVEL_EVENTS... What I want, is to do exactly this in SQL 2000.
--
Thx,
Anthony E. CastroThere is no easy solution in 2000. If you really want this I recommend you
upgrade vs. spending the effort in 2000. But you can run a trace filtering
on only those type events but this is not a good long term solution. You can
also try one of the 3rd party tools to audit the tran logs but that has down
sides as well. Take a look at the free tool from www.red-gate.com for log
audits.
Andrew J. Kelly SQL MVP
"acmcdba68" <acmcdba68@.hotmail.com> wrote in message
news:8E8FE948-9D8A-4524-BF57-9EBA8CA9DF60@.microsoft.com...
> Rather than reinvent the wheel, I was hoping that there was someone who
> has
> already created a script allowing for the auditing of DDL statements,
> schema
> changes within the database for SQL Server 2000.
> I can easily capture the aforementioned in SQL 2005 by making use of a
> trigger on
> DDL_DATABASE_LEVEL_EVENTS... What I want, is to do exactly this in SQL
> 2000.
> --
> Thx,
> Anthony E. Castro