Discussion on:

Audit data using SQL Server 2005's COLUMNS_UPDATED function

Is there a way to tell when the last time a DB has been accessed by using a query, sp, etc? I do not want to browse the log files of over 82 databases.

Thanks in advance

Great piece!

Ok, so this raises the question "How does one generate a list of changed columns wit their column name, original value and new value?"

well i have a kind of different requirement if you could please suggest. i need to save the complete record as it was before any DML operation. I am making a history table for all the tables having the same schema but two additional fields having update on (date) and udated by (user id) and i need to insert the data in history table for each record updated in any table in the respective history table. thanks

This solution works great. The problem I'm having is reading the UpdatedColumns field in the SalesHistoryAudit table. For example this what I have stored in that field.

I've been trying everything to read that xml data but all I can get it to do is return null or blank. Do es anybody have any suggestions.

i have aretail database we maintain sale as sales persan wise ,but it showing wrongly report ,how i can solve this problem