<div>
thanks, we have discussed doing that same thing but still want to see if anyone has a method to do this. 
</div>


thanks, we have discussed doing that same thing but still want to see if anyone has a method to do this.

<div>
I have to confirm above. ..
</div>


<div>
<div class="content wysiwyg-content">
Situation:<br />
I currently have some SQL Server 2000 Tables that have triggers applied to notify the development team if any data is deleted, updated or inserted. &nbsp;If they are we send out email notifications to let us know what data is changed. &nbsp; But now they are asking us to setup the same type of process if the table structure is changed, i.e. &nbsp;If a column name changes, or new column added or colum deleted or datatype changed. &nbsp;Those are the types of changes we want to track. &nbsp; &nbsp;Does anyone have some examples or explain what method this can be done?
</div>
</div>


Situation:
I currently have some SQL Server 2000 Tables that have triggers applied to notify the development team if any data is deleted, updated or inserted.  If they are we send out email notifications to let us know what data is changed.   But now they are asking us to setup the same type of process if the table structure is changed, i.e.  If a column name changes, or new column added or colum deleted or datatype changed.  Those are the types of changes we want to track.    Does anyone have some examples or explain what method this can be done?

Setting up Notification on Table Structure Changes

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.