Update database statistics
Database statistics are used to ensure that your database is providing data to
Accounting CS
as efficiently as possible. Typically these statistics are automatically updated, as required. Manually updating the statistics can be useful if response times are slower than usual or if a significant number of changes have been made to the data at once.Select
Help
, then Update Statistics
to manually update the statistics in the database.important
This command isn't available if you're workingin the Virtual Office CS or Software as a Service (SaaS) environments where the database is maintained by the administators at Thomson Reuters.
What to do if the process fails
If the process fails, contact your database administrator to verify the following configurations.
- The server authentication mode is set toSQL Server and Windows Authentication modefor your SQL Server instance.
- The database owner login CreativeSolutionsPracticeCsDatabaseOwner exists
- The database owner login CreativeSolutionsPracticeCsDatabaseOwner has the proper permissions. Grant permission is required forConnect SQLandView server state. If one or both isn't granted, you can execute the following script.USE MASTER; GRANT CONNECT SQL, VIEW SERVER STATE TO CreativeSolutionsPracticeCsDatabaseOwner;
- There is sufficient RAM available on both the workstation and the server.
After confirming these items, select
Help
then Update Statistics
to manually update the statistics in the database.
