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.