Computed column error

• coolchaitu

  SSChampion

  Points: 10334

  More actions

  July 15, 2010 at 9:06 am

  #141043

  Hi,

  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.

  Thanks

  Kiran

• RTaylor2208

  SSChampion

  Points: 13298

  More actions

  July 16, 2010 at 5:12 am

  #1194000

  Can you please provide the source and destination table creation scripts and some sample data? Otherwise no one can really help you.

  MCITP SQL 2005, MCSA SQL 2012