Sign in
Microsoft.com
 
Microsoft
 
 
 

none
If Change Tracking is enable for a table when is the SYS_CHANGE_CREATION_VERSION is set to Null. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    We have a table for which the change tracking feature is enable in the database. When we used the CHANGETABLE() method to fetch the list of records modified for that particular table, the result set displayed that SYS_CHANGE_CREATION_VERSION column value is set to Null for some of the table rows but for rest of the rows the SYS_CHANGE_CREATION_VERSION column is set correctly with the change tracking version no..

    Please advice in what scenario will the SYS_CHANGE_CREATION_VERSION is set to null!!Thanks in advance..

    Friday, May 3, 2013 12:27 PM
    |

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    are those rows where SYS_CHANGE_CREATION_VERSION is set to null inserted before you enabled change tracking?
    Wednesday, May 8, 2013 6:24 AM
    |
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

                We have verified that those rows were inserted after enabling the change tracking only. Still SYS_CHANGE_CREATION_VERSION is set to null, But surprisingly the SYS_CHANGE_VERSION columns has a values other than null. How is it possible??

    Tuesday, May 14, 2013 10:27 AM
    |