2 Resources for

COLUMNS_UPDATED

Sponsored White Papers, Webcasts, and Downloads

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

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

Quick Guide: Spyware Detection and Removal: Spyware and adware are increasingly eating away at IT professionals' time and resources. These programs slow end-user system performance and can enabl ...; Buy Now

Disaster Recovery Plan Power Checklist: Development of a disaster recovery plan is a must. Although there may never come a time when the plan must be implemented, it is always best to prepar ...; Buy Now