Enabling access from other applications
Using Advanced Company Settings to maintain database history
Advanced Settings in Database Administration are sophisticated tools that enable you to take advantage of the power and flexibility of SQL Server, even if you have no expertise in SQL Server Management Studio.
Database activity history is maintained in separate audit tables, which you can query using SQL Server Management Studio to view details about changed records, such as the date and user ID of the employee made the change.
You use the options on the Advanced Company Settings tab to specify how long to keep database history for each Sage 100 Contractor company you manage. Details older than the retention period you specify are cleared during nightly maintenance.
You can also purge all database history for a selected company by clicking the [Purge History Tables] button.
You use the options on the Advanced SQL Server Settings tab to maintain tight security and exert fine control over user and program access to your SQL Server instance.
IMPORTANT: The settings you choose on this tab apply to all the databases in the SQL Server instance, not just to one company.
For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.
For additional training on Sage products, visit Sage University.