What are you planning to audit.

By the way, in SQL Server 2008 there is a new cool feature called AUDIT.

You will find it in Management Studio. You could plan to use it.