Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

In SQL 2008, I have change tracking turned on both on the database and table levels, with column tracking turned on at the table level. The CHANGETABLE(CHANGES...) function returns the expected results, however CHANGE_TRACKING_IS_COLUMN_IN_MASK always returns 0, even if the given field has changed in a row.

In addition, the sys.dm_tran_commit_table view is empty, and sys.change_tracking_{table object id} returns an "Invalid object name" error.

My conclusion is that general change tracking is functioning correctly, but column tracking is not functioning correctly (and it is definitely turned on). I have followed the steps from multiple tutorials to the letter, but am not getting the results that those tutorials describe--am I missing something?

share|improve this question
Any chance you could include your table schema and the change tracking commands you have run on it so we can repro the issue? –  Timothy Walters Sep 4 '13 at 6:02
add comment

migrated from stackoverflow.com Feb 7 '12 at 20:51

This question came from our site for professional and enthusiast programmers.

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.