I have a database that was created in SQL Server 2000 I presume, although I am not certain.
I am used to creating primary keys on identity columns.
This table however had the fields s_collineage, s_generation etc which I believe created for replicated databases.
Is it safe to remove them?
Also, the primary key in this field is an int columns with a default value of 0.
Whenever a new record is created, that field is populated with a random int value. I don't understand how this value is generated. I checked the column properties but cannot figure it out.
Any help would be greatly appreciated.
I think i know why this is happening.
This used to be an access database i believe setup for replication. When that is done all autonumbers are changed to just ints to prevent the duplicated auto incremented numbers.
I checked the sql server database and it is not setup for replication. Maybe they just ran the wizard to upgrade to sql, not sure.
I will just change the fields to autonumbers again and mark the relationships to cascade update.