Is there anyway in SQL Server to know when a column is added to the table?

Question

I was wondering if there is any way in SQL Server to know when a specific column is added/modified in a table.

When I try the following code, I can not see any track of columns, it includes only tables and foreign keys.

select * from sys.objects
order by modify_date desc

any idea?

Answer 1

I'd take a look at Event Notifications and see if you can create a solution from the info there.

I'll admit to never using them for this purpose, and it may be overkill for your needs but it should do the trick.

EDIT : Oh, and DDL Triggers may be less involved and still give you what you need.