Setting up Notification on Table Structure Changes
Posted on 2010-09-14
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?