【解决方案】
备份好账套，在账套库中执行以下脚本，执行完毕后，再升级。注意：执行脚本时别选错账套
declare @tablename varchar(100),@columnname
varchar(100),@tab
varchar(100)
set @tablename =
'RE_Retail_b'
set @columnname =
'iscancel'
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
