Trigger alter and create table SQL Server 2008

Asked May 05 '14 at 18:46

Active Jul 29 '14 at 22:01

Viewed 42 times

I would like to feed a table with all the updates and alters of tables in my database. For example: if I add a column called testColumn in the table Test my table would have something like this:

TABLE    COLUMN         DATE
Test     testColumn     2014-05-05 05:25:31

I tried this using sys.tables and sys.columns but it doesn't work

Someone can help me?

edited Jul 29 '14 at 22:01

AdamL

12,421
5
50
74

asked May 05 '14 at 18:46

Vamperst

What do you mean it doesn't work? What have you tried thus far? – Ben Black May 05 '14 at 19:13
Do you need the datetime, at which the a new column has been added to the table? – RajeshKannan May 05 '14 at 19:28

Trigger alter and create table SQL Server 2008

0 Answers0