You can execute the extended.stored procedure
xp_loginconfig:
exec master..xp_loginconfig 'audit level'

It's also located in the registry . Which key depends on
what version, instances, etc. but it's the value for
AuditLevel
For a default instance of SQL Server 2000, the location is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer
For a default instance of SQL Server 2005, the location is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer
The values for AuditLevel are:
0 = None
1 = Success
2 = Failure
3 = All

-Sue

On Mon, 11 Sep 2006 07:20:02 -0700, Blue Sky
<BlueSky@discussions.microsoft.com> wrote:

>I have multiple SQL servers and want to run a remote query on each of them to
>determine their Audit level... (None, Success, Failure, All). Where is this
>information stored, that i might query it?
>
>Thanks!