Super easy SQL Server 2005 Database Schema change auditing(blogs.geekdojo.net)
submitted by 
jamesewelch(2275) 4 years, 4 months ago
Here's a very simple way to make use of xml type in SQL Server 2005: audit all the object/schema changes to the database with a simple database-level trigger. It's like a poor man's source control for schema changes. But also, it could come in very handy for forensic purposes when diagnosing post-rollout issues or accidental schema changes. Anyway, it's simple and handy for what it does.
|category: Database
|Views: 31
tags:
trigger Audit XML Database SQLServer another
Everyones tags:
Your Tags: