日结失败
技术咨询，有偿服务！
复制微信号
原因分析：数据库表错误
问题解答：执行下列sql语句前，请先备份好数据在查询分析器中执行语句修复坏表的数据库--不丢数据.sqluse mastergoALTER DATABASE BUSINESS_EIP SET OFFLINE WITH ROLLBACK IMMEDIATEgoALTER DATABASE BUSINESS_EIP SET ONLINE WITH ROLLBACK IMMEDIATEgosp_dboption 'BUSINESS_EIP', 'SINGLE USER', TRUEgoDBCC CHECKDB('BUSINESS_EIP', repair_rebuild)goDBCC CHECKDB('BUSINESS_EIP', repair_rebuild)gosp_dboption 'BUSINESS_EIP', 'SINGLE USER', FALSEgo如还不行则执行修复坏表的数据库--丢数据.sqluse mastergoALTER DATABASE BUSINESS_EIP SET OFFLINE WITH ROLLBACK IMMEDIATEgoALTER DATABASE BUSINESS_EIP SET onLINE WITH ROLLBACK IMMEDIATEgosp_dboption 'BUSINESS_EIP', 'SINGLE USER', TRUEgoDBCC CHECKDB('BUSINESS_EIP', REPAIR_ALLOW_DATA_LOSS)gosp_dboption 'BUSINESS_EIP', 'SINGLE USER', FALSEgo注：这个SQL执行会清掉现有没结账的台号数据，所以只能在营业结束的时候执行