821版本升级错误

iufida

821版本2002年度数据在升级（无论至821以上任意版本）均提示错误，-2147467259
未能在索引页 (1:26490) 中找到 RID ＇1661562f38010000＇ 的索引条目（索引 ID 0，数据库 ＇UFDATA_008_2002＇）。

执行如下语句时出错:
--zhengyun--


--显示因做过复制增加了主键和字段的表名和主键名
--select so1.name, so2.name
--from sysobjects as so1 inner join sysobjects as so2 on so1.id=so2.parent_obj
--where so1.xtype=＇u＇ and so2.xtype=＇pk＇ and so1.id in (select id from syscolumns where name=＇ufguid＇)

--删除因做过复制增加的主键
declare @str_Sql varchar(500)
declare @str_Old_TableName varchar(100)
declare @str_Old_PKname varchar(100)
set @str_Sql=＇＇
set @str_Old_TableName=＇＇
set @str_Old_PKname=＇＇
declare Cur_tmpPK cursor for select so1.name, so2.name
from sysobjects as so1 inner join sysobjects as so2 on so1.id=so2.parent_obj
    where so1.xtype=＇u＇ and so2.xtype=＇pk＇ and so1.id in (select id from syscolumns where name=＇ufguid＇)
    order by so1.name
OPEN Cur_tmpPK
FETCH next FROM Cur_tmpPK INTO @str_Old_TableName, @str_Old_PKname
WHILE @@FETCH_STATUS = 0
BEGIN
    print @str_Old_TableName ＋ ＇  ＇ ＋ @str_Old_PKname
    set @str_Sql=＇ALTER TABLE ＇ ＋ @str_Old_TableName ＋ ＇ DROP CONSTRAINT ＇ ＋ @str_Old_PKname
    print @str_Sql
    exec (@str_Sql)
    FETCH NEXT FROM Cur_tmpPK INTO @str_Old_TableName, @str_Old_PKname
end
CLOSE Cur_tmpPK
DEALLOCATE Cur_tmpPK
[2008-8-18 15:32:52 补充] DDD
[2008-8-18 15:35:22 补充] 上传数据时提示没有权限，用户的数据有90M,请问是否还有其他上传方式，能否通过远程？
[2008-8-19 17:51:25 补充] 数据已上传
[2008-9-3 16:07:07 补充] 错误信息:
-2147217900
在被引用表 ＇Inventory＇ 中没有与外键 ＇FK__ProductExParent__Inventory_cInvCode＇ 的引用列的列表匹配的主键或候选键。

执行如下语句时出错:

--原产品结构
if not exists (select * from sysobjects where id = object_id(N＇[dbo].[ProductStructureEx]＇) and OBJECTPROPERTY(id, N＇IsUserTable＇) = 1)
CREATE TABLE [ProductStructureEx] (
[cPSPCode] [varchar] (20) NOT NULL ,
[cDepCode] [varchar] (12) NULL ,
CONSTRAINT [ProductStructureEx_PK] PRIMARY KEY  NONCLUSTERED
(
[cPSPCode]
)  ON [PRIMARY] ,
CONSTRAINT [FK__ProductExParent__Inventory_cInvCode] FOREIGN KEY
(
[cPSPCode]
) REFERENCES [Inventory] (
[cInvCode]
)
) ON [PRIMARY]