columns_updated

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Audit data using SQL Server 2005's COLUMNS_UPDATED function

Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has been modified, it is also useful to track the individual field names that have been modified. This information is great for your auditing department, and it...

Tags: Function, Audit, Microsoft SQL Server, Auditing, Trigger, Microsoft SQL Server 2005, COLUMNS_UPDATED, COLUMNS_UPDATED Function, System Function, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman

Blog posts 2008-05-13

Audit data using SQL Server 2005's COLUMNS_UPDATED function

DBA Tim Chapman looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has...

Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, COLUMNS_UPDATED, Databases, Enterprise software, sys.fn_IsBitSetInBitmask, trigger, update statement, audit, SQL Server Newsletter, Function, Auditing, Microsoft SQL Server 2000, Listing B, COLUMNS_UPDATED Function, System Function, Listing C, Software, Data Management

Technical articles 2007-04-16

Additional Resources

Audit data using SQL Server 2005's COLUMNS_UPDATED function

QuestionIs 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

Tags: Databases, ITPains, Microsoft SQL Server 2005, audit, Microsoft SQL Server

Discussion threads 2007-04-17