SQL Server CDC(change data capture) is used just for table data change? Can I use it to track procedure or other types of objects change?
SQL Server CDC(change data capture) is used just for table data chang开发者_StackOverflow中文版e? Can I use it to track procedure or other types of objects change?
BTW, are there some companies using CDC
in their production?
Thanks.
As the name says it captures DATA change - and SP's are not data.
it is not meant to capture the database changes, but to be a fast mechanism for a data warehouse to see what ata has been added / changed.
You can create a database trigger to capture DDL changes on a database.
http://msdn.microsoft.com/en-us/library/ms190989%28v=SQL.90%29.aspx
精彩评论