How to get the ddl of every change in the database

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

How to get the ddl of every change in the database

Author

Topic

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2008-03-15 : 02:02:54

How to get the ddl of every change in the database
Includes changes in the table, column, constraints's
That is a new table added, table drop table name changed, column type change column added, primary keys , foreign key, check constraints e.t.c

I am not looking for the changes in triggers. stored procedures, functions.

Kamran Shahid
Sr. Software Engineer(MCSD.Net)
www.netprosys.com

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-15 : 03:26:52

Check out the new DDL-triggers available in SQL Server 2005.

E 12°55'05.25"
N 56°04'39.16"

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2008-03-15 : 04:16:03

I Know about that but I am also looking for a generic solution which could work in sql server 2000 as well

Kamran Shahid
Sr. Software Engineer(MCSD.Net)
www.netprosys.com

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-03-15 : 04:39:52

quote:
Originally posted by kamii47

I Know about that but I am also looking for a generic solution which could work in sql server 2000 as well

Kamran Shahid
Sr. Software Engineer(MCSD.Net)
www.netprosys.com

DDL triggers are not available in SQL Server 2000

Madhivanan

Failing to plan is Planning to fail

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2008-03-15 : 09:48:12

Then any other technique ?

Kamran Shahid
Sr. Software Engineer(MCSD.Net)
www.netprosys.com

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-03-15 : 11:22:09

use profiler

KH
[spoiler]Time is always against us[/spoiler]

rmiao
Master Smack Fu Yak Hacker

7266 Posts