Is There Anyway In Sql Server To Know When A Column Is Added To The Table?
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
Solution 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.
Post a Comment for "Is There Anyway In Sql Server To Know When A Column Is Added To The Table?"