Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Computed column error Expand / Collapse
Author
Message
Posted Thursday, July 15, 2010 9:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 12:15 PM
Points: 10, Visits: 354
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
Posted Friday, July 16, 2010 5:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 11, 2014 6:37 AM
Points: 299, Visits: 561
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
Post #953758
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse