Re: Audit Log in Yukon

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D112D80B-A00F-4D37-85AB-F0B3A96F4542@xxxxxxxxxxxxxxxx
> Hi There,
>
> Can someone tell me if there is any difference in the audit log available
> in
> SQL Server 2000 and Yukon?
>
> TIA
> irfan


.

Relevant Pages

  • Re: 18454 Log message
    ... You may check if your server-in-question is setup for auditing. ... --Right-click the server, and then click Properties. ... SQL Server™ are recorded in the SQL Server error log: ...
    (microsoft.public.sqlserver.security)
  • Re: Backup not working HELP!
    ... see the error log located in the backup directory. ... the SQL Server error log for more details. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SQL 2000 Error: 17803, Severity: 20, State: 14
    ... OK your running 2000 SP3 but what edition? ... Server or ADV Server? ... How is the memory configured on SQL Server? ... same messages in the error log. ...
    (microsoft.public.sqlserver.server)
  • SQL Error Log is not logging events properly
    ... I have a server where the sql error log is constantly missing events. ... Usually you see when processes were killed, backups, server reboots, etc. ...
    (microsoft.public.sqlserver.security)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)