Computed column error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Computed column error

Computed column error

Rate Topic

Display Mode

Topic Options

Author

Message

coolchaitu

Posted Thursday, July 15, 2010 9:06 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, March 18, 2013 11:35 PM
Points: 10, Visits: 308

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

Post #953225

RTaylor2208

Posted Friday, July 16, 2010 5:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 10:04 AM
Points: 126, Visits: 328

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

Post #953758

« Prev Topic | Next Topic »

Permissions