Monday, March 19, 2012

How can I log DDL?

Hallo,
in Oracle I use DDL-Trigger. But how can I document/triggering DDL (for instance "alter table") in Microsoft SQL Server?
Regards, Doreenwhich version of SQL server are you using? DDL triggers are introduced in SQL Server 2005.|||I have to create a history of tables. Therefore I must know the previous structure of the table. I have to document the changes of the structures of the tables.
Is there a solution for the version 2000?

No comments:

Post a Comment