Default Trace Audit F.A.Q.:

Q: How much data is stored in the default trace and for how long?

A: Depends on how busy the server is; the Default trace has 5 files 20 Mb each, and depending on how many events are written to the Default trace files, the files may roll over and overwrite the oldest file.

Q: Can we change the settings of the Default trace in SQL Server?

A: No. More details can be found here.

Q: Do I need to install this tool on every server?

A: No, you can install the tool on one server and use the SQL Server Management studio to connect to any server in the network and run the reports this way.

Q: What should I do if I find bugs or if I have questions and comments?

A: Send a message to the author by using the contact form.