Thanx Guys.
SET IDENTITY did not work.
So, here is what did work.
I am using Navicat and was trying to syncronize the data.
This problem only occurred for Aware Reference tables.
In the system I was syncronizing From the table is.... STOREAWARE_ACTIVITIES_REF
In the system I was syncronizing To the table is ACTIVITIES_REF
Hence my trying to syncronize rather than transfer. Using transfer you cannot specify a target name and the Transfer also Creates the table.
Shut down Aware....
OK.... so in Target DB... Dropped ALL _Ref Tables
Used Navicat to Transfer (not Syncronize) all _Ref table from source DB to target db.
Now in the target Aware DB, all of those tables now exist but are named incorrectly..
In SQL Server Management Studio..... Go into the Design for each of these table and View Properties. Edit the table names to removed the bs prefix.... ie STOREAWARE_ACTIVITIES_REF becomes ACTIVITIES_REF
Save and done.
All works... so far.