I've just been assigned to take over the "audit" project from a contractor (not renewed, and also tended not to make lots of notes if at all on what were doing....) Got hit with the trick task of "document what has been going on and plan a course of action"....

I've been going through the on-line manuals as well as Sybooks, and the isntallation does not make use of the sp_audit..... command but the older command sequence "sp_audit".

Does anyone have a script that I could run to extract the current settings for auditing?

Alternately, where do I dig out the information on where the audit settings are stored and how to pull out the information?

I guess that I should also ask for input as to which settings are most useful from a security viewpoint.