Friday October 9th

Thursday October 8th

Super easy SQL Server 2005 Database Schema change auditing

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.


Commenting on Stories is limited for now and will open up to those recommended by the community. Learn how
Loading DotNetKicks...
brought to you by the Kicks Network