Solved

Setting up Notification on Table Structure Changes

Posted on 2010-09-14
3
392 Views
Last Modified: 2012-05-10
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?
0
Comment
Question by:jholmes0724
3 Comments
 
LVL 8

Accepted Solution

by:
mustaccio earned 500 total points
ID: 33674279
If you had SQL Server 2005 you could use DDL triggers for that:

CREATE TRIGGER t1 ON DATABASE FOR ALTER_TABLE ...

With SQL Server 2000 I'm afraid you are out of luck. As a workaround, you could set up a scheduled job that would compare contents of the COLUMNS information schema view with its previous contents saved in a backup table...
0
 

Author Comment

by:jholmes0724
ID: 33674326
thanks, we have discussed doing that same thing but still want to see if anyone has a method to do this.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 33680505
I have to confirm above. ..
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now