【问题解决】
1、全盘搜索DATA_DSTR_EAP_Mix_NL-11001文件,找到后右键以记事本方式打开该文件,全部复制后到数据库中对相应的账套执行

2、执行出现报错,双击红色字体,自动定位至错误的表名,复制表名与列名

3、案例中表名为:EAP_DetailAtt 列名为:FileContent,将出错的表名和列明替换至下面的语句中:
declare @tablename varchar(100),@columnname
varchar(100),@tab varchar(100)
set @tablename = ‘表名’
set @columnname = ‘列名’
declare @defname varchar(100)
declare @cmd varchar(100)
select @defname = name from sysobjects so
join sysconstraints sc on so.id = sc.constid where
object_name(so.parent_obj) =@tablename and
so.xtype =‘d’ and sc.colid = (select colid from syscolumns
where id = object_id(@tablename) and name
=@columnname)
select @cmd = ‘alter table ’ + @tablename
+‘ drop constraint ’ + @defname
if @cmd is null
print ‘no default constraint to drop’
exec(@cmd)
Go

4、再次到数据库中对此账套执行以下脚本,完成后重新升级账套即可
