数据库升级后打开表或存储过程出错(可解决)

ehxz

免费乐捐，感谢支持

原来的数据库在ASE12.5.01+10430的EBF是正常的，后来升级到更高的12.5.03的14499再打开库的表或存储过程都出类似的错误：
cannot run query--referenced object (name NAME NOT RECOVERABLE)dropped during query optimization.
应该如何解决。只有用户库这样，其它的库正常。除了BCP重新导出导入，会不会还有别的方法解决。这种问题是如何发生的？

ehxz

CSDN hobbylu(东方一剑) 提供解决方案： http://community.csdn.net/Expert/topic/3494/3494602.xml?temp=.9650537

use dbname

go

delete statistics syslogins

go

delete statistics sysusers

go

delete statistics sysattributes

go

delete statistics sysalternates

go

delete statistics sysobjects

go

delete statistics systypes

go

delete statistics sysprotects

go

delete statistics syscolumns

go

delete statistics syssegments

go

delete statistics systhresholds

go

update statistics syslogins

go

update statistics sysusers

go

update statistics sysattributes

go

update statistics sysalternates

go

update statistics sysobjects

go

update statistics systypes

go

update statistics sysprotects

go

update statistics syscolumns

go

update statistics syssegments

go

update statistics systhresholds

go