Monitoring Changes to your Database Schema  June 28, 2007  How
can you monitor changes to your Database Schema? Why would you
want to track changes to your database structure? You might want
to track changes to your database data definitions for a number
of different reasons. With the introduction of SQL Server 2005,
Microsoft now allows you to write Data Definition Language (DDL)
triggers to perform actions when events occur on your server. In
this article, I will discuss some of the things that DDL
triggers could be use for, as well as show you a few DDL trigger
examples.  Why Might You Want to Create a DDL TRIGGER?  So why
would you want to track changes to the underlying structure of a
database? The reasons for doing this are probably different in
every SQL Server 2005 environment. Here is a list of a few
possible situations where DDL triggers might be useful:    • You
work in an environment where many developers can create new
databases, and you would like to get an email notification when
each new datab