? bug where autoincrement column's next value is # of records - not highest value +1 ? RRS feed

  • Question

  • Is there a known bug where an auto-increment field in an .sdf file created by Sync Services does not have the correct "next auto increment" value?

    when SF creates my .sdf file the next auto-increment value is the number of records ... not the highest number in the column +1 as expected.

    Thursday, July 8, 2010 6:02 PM

All replies

  • check this out: http://msdn.microsoft.com/en-us/library/bb726019.aspx

    to quote:

    "Identity columns are copied from the server to the client database, but the identity seed and increment are always set to 0 and 1, respectively. This is regardless of how the properties were set in the server database. SQL Server Compact identity columns must have a data type of int or bigint. SQL Server Compact identity columns cannot have a data type of smallint, tinyint, decimal, or numeric. For more information about identity columns"


    Friday, July 9, 2010 1:50 AM