Audit Log in Yukon

Hi There,
Can someone tell me if there is any difference in the audit log available in
SQL Server 2000 and Yukon?
TIA
irfan
Do you mean the Audit Level server setting that writes entries to the SQL
Error Log? The biggest change is the logging of the IP address. There are
also a number of other options for collecting this information e.g. the
default trace or event notifications (via TSQL or WMI). In earlier builds
the Audit Level was set to All by default but sanity seems to have prevailed
and the default setting is now Failure.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Irfan" <Irfan@.discussions.microsoft.com> wrote in message
news:D112D80B-A00F-4D37-85AB-F0B3A96F4542@.microsoft.com...
> Hi There,
> Can someone tell me if there is any difference in the audit log available
> in
> SQL Server 2000 and Yukon?
> TIA
> irfan