In a project, we need to capture the whole transactions of the database for further notes. I implemented a solution while ago using triggers etc… But SQL Server 2008 is providing a great capability built in called Change Data Capture which can find how to implement it here.
BTW, we are planning to move our SQL Server Farm in our hosting company to SQL Server 2008 hopefully soon… I’ll keep my readers posted here.