問題現(xiàn)象：清空年度賬時提示已經(jīng)有客戶使用[333]賬套[2009]，年度賬，不能清除!

解決方案：經(jīng)查看沒有操作使用也沒有任務(wù)或鎖定信息，可通過在數(shù)據(jù)庫中刪除年度賬來重新建立來操作。

以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