I am exporting data using bcp from primary server to text files and importing them using bcp to secondary server. I have executed this in SQL Server 2000 and it worked fine. The database has been upgraded to 2005 and when i run the import its throwing me the following error :
Metadata stored on disk for computed column "%" in table "%" did not match the column definition. In order to avoid possible index corruption, please
drop and recreate this computed column
I do not want to drop and recreate the computed column as that is the business policy. Can anyone pleasew let me know how to deal with this in other ways.