I don't recommend using triggers. By the time you've thought of everything you want to audit, you'll have so many triggers that you won't know how to manage them all. You can build your own solution using Service Broker or any of several other technologies built into the SQL Server platform. If you don't want to do that, there are several third party tools that will handle it all for you.

John