0

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?

BTW, are there some companies using CDC in their production?

Thanks.

Just a learner
  • 26,690
  • 50
  • 155
  • 234

2 Answers2

1

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.

TomTom
  • 61,059
  • 10
  • 88
  • 148
1

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

Mikael Eriksson
  • 136,425
  • 22
  • 210
  • 281