Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dmaniac
Starting Member
3 Posts |
 Posted - 2007-02-15 : 10:52:31
|
| New to the scene so watz up to the house!! My question? I want to know imediatly when someone changes a column name or data type of a table. DDL triggers will tell alert me on data type changes but not column name changes. I can certainly create my own trigger but was wondering if something already exist and I just havent come accross it yet. Just trying to avoid re-inventing the wheel. Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-15 : 10:56:40
|
| Column names are stored in system tables and are accesible by INFORMATION_SCHEMA views.Maybe you should ty to set a trigger for those?Peter LarssonHelsingborg, Sweden |
 |
|
|
dmaniac
Starting Member
3 Posts |
Posted - 2007-02-16 : 11:00:30
|
| Thanks man.got some other leads I need to explore.sp_foreachtabl, sp_foreachdb, & DBCC RENAMECOLUMNI'll take a stab when I get some time. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-02-16 : 11:43:18
|
| Best solution. STOP others executing DDL!If you are the DBA....only you should ROLL-OUT DDL scripts.All other strategies are like chasing wind....pointless and often smelly! |
|
|
|
|
|
|
Monitor column name changes