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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

migration rejected from stackoverflow.com Mar 24 at 16:43

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Max Vernon, Phil, Erik, swasheck, ypercubeᵀᴹ Mar 24 at 16:43

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Phil, Erik, swasheck, ypercubeᵀᴹ
If this question can be reworded to fit the rules in the help center, please edit the 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