This will configure SQL so that it works well with RMS; from Jeff Hobbs (Check Point Software). If HQ environment, all dbs should be configured with these settings including any offline dbs. Run one a...
Backup db and restore at new location running same version of RMS. Clear transactions using Administrator. Set all inventory to zero using Wizard or script. Run committed qty script from this KB artic...
The default SQL password for RMS installations is: Password1 If a different password was entered during installation and you have forgotten that password the following article explains how to reset t...
BACKUP First!! Simpler option: DELETE FROM journal WHERE time < GETDATE() - (365 * X) where X is number of years ago To delete the Journal (receipts) older than 5 years, enter this into a new query in...
If you are running the full version of SQL Server 2000 or 2005, make sure the memory settings are not set too high. If set too high, SQL will hog server memory and degrade network performance and data...
As your MSDE (Microsoft SQL Desktop Engine) approaches the 2G limit, you will begin to receive errors in RMS during database updates. Also, MSDE is no longer supported by Microsoft. RMS 2.0 includes a...