>>
>>There are two ways without a trigger: Change Data Capture and SQL Server Audit.
>>
>>For Change Data Capture you can check this very good article
>>
http://blogs.lessthandot.com/index.php/datamgmt/datadesign/change-data-capture-sql-server-08/>
>Naomi, just curious, do you use CDC in any database applications?
No, we don't use it. We are using activity log and only log into it specific activity. In some tables we do have user who modified the data last.
If it's not broken, fix it until it is.
My Blog