Suspected Database Recovery Query

If you find that your any database is suspected then plz restore your recent backup its recommended solution. If you have not your recent backup of this suspected database then you will use this given query with your Divisional Head permission.

EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER  

Type Mismatch error when trying to Submit Account at Point Of Sale

This is a database error. Firstly contact PTC Mysore for solution but if you have not much time and your daily work is suffering from it then check your Transaction details ( RL and Speed Post) in report you will see any one transaction or more are not showing Bar code or Weight etc. Now go to SQL Management Studio and open Counter Database and open Table named Mail and search these defaulter entries on that days entries. Correct them with authenticate data and close Management Studio. Now see again Submit Account and you will see your problem is resolved.