解决方案: |
作升级前不能打最新的hotfix和dbhotfix补丁(即已经打包了出口管理的补丁),执行一下语句后再作升级。 use ufdata_002_2004 go --修复数据库 sp_dboption 'ufdata_002_2004','single user','true' go DBCC DBREINDEX ('ufdata_002_2004.dbo.rdrecords', InventoryRdRecords, 70) DBCC DBREINDEX ('ufdata_002_2004.dbo.currentstock', WarehouseCurrentStock, 70) DBCC DBREINDEX ('ufdata_002_2004.dbo.dispatchlists', InventoryDispatchLists, 70) go sp_dboption 'ufdata_002_2004','single user','false' go --删除表rpt_folder的主键primarykey --alter table rpt_folder --drop constraint primarykey --删除表U8LangResource外键约束FK_U8LangResource_U8LangDefine_LocalID alter table U8LangResource drop constraint FK_U8LangResource_U8LangDefine_LocalID --删除表U8LangDefine的主键PK_U8LangDefine alter table u8langdefine drop constraint pk_u8langdefine --删除表U8LangResource外键约束FK_U8LangResource_U8LangDefine_LangID alter table U8LangResource drop constraint FK_U8LangResource_U8LangDefine_LangID --删除表U8LangDefine的索引IX_U8LangDefine alter table U8LangDefine drop constraint ix_u8langdefine |