清空年度账时提示已经有客户使用[333]账套[2009]，年度账，不能清除!

问题现象：清空年度账时提示已经有客户使用[333]账套[2009]，年度账，不能清除!

解决方案：经查看没有操作使用也没有任务或锁定信息，可通过在数据库中删除年度账来重新建立来操作。

以333账套删除2009年度账为例，SQL语句：

use UFSystem

delete from UA_Account_sub where cAcc_Id=333 and iYear=2009

delete from UA_BackupLog where cAcc_Id=333 and iYear=2009

delete from UA_BackupPlans where cAcc_Id=333 and iYear=2009

delete from UA_HoldAuth where cAcc_Id=333 and iYear=2009

delete from UA_Log where cAcc_Id=333 and iyear=2009

delete from UA_Period where cAcc_Id=333 and iYear=2009

delete from UA_Task where cAcc_Id=333 and iYear=2009

Drop database ufdata_333_2009

温馨提示：近期载地址失效频繁，如链接失效请点击此处查阅详情！