Avatar of BFanguy
Flag for United States of America

asked on 

sqlserver 2008r2 table with records with duplicate rowid

A user at my company used access to backdoor adding "PART" records to SQLServer 2008R2 ERP database.  Unfortuantly he used 1 for all the ROWID's.   These records have been used all over the place in the database.  My question to you guys is, can i just manually edit the table and assign uniquie ROWID's to them?  i.e. does SQL use these rowid's as foreign keys?

I am trying to upgrade a sandbox of our production database and it's failing due to duplicate keys in other tables.

Any help is greatly appreciated.
Microsoft SQL ServerMicrosoft Access

Avatar of undefined
Last Comment
Jim Horn

8/22/2022 - Mon