What is the best practice for C2 audit option with in SQL 2005 ? I can enable it but what is next how can I configure the trace log size ? locations of the logs etc I looked online and I couldnt be able to find any helpful answer other just enabling and disabling it any guidance will be appreciated