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 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2010-06-04 : 09:16:51
|
| Does someone knows where I can retrieve the old object definition after a ddl change is made, using ddl triggers?I can't seem to understand why the eventdata or cdc.ddl_history logs the current definition since that one can be seen anyways using object_definition./Jen--------------------keeping it simple... |
|
|
jimmycjen
Starting Member
15 Posts |
Posted - 2010-06-08 : 16:42:17
|
| One place you can look for DDL changes (in SQL 2008) is from Schema Changes History - right click the desired database ans select Reports --> Standard Reports --> Schema Changes History |
 |
|
|
|
|
|
ddl triggers