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

  • Question

  • 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

  • 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
  • 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