Skip to main content
Update

Manually 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 needed. 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.
  1. Select
    Help
    , then
    Update Statistics
    .
    note
    This command is not available if you are working in the Virtual Office CS (VO) or Software as a Service (SaaS) environments where the database is maintained by the administrators at Thomson Reuters.
  2. If the process fails, contact your database administrator to verify the following configurations:
    1. The
      Server authentication mode
       is set to
      SQL Server and Windows Authentication mode
       for your SQL Server instance.
    2. The database owner login
      CreativeSolutionsPracticeCsDatabaseOwner
       exists.
    3. The database owner login
      CreativeSolutionsPracticeCsDatabaseOwner
       has the proper permissions.
      note
      Grant
       permission is needed for
      Connect SQL
       and
      View server state
      . If one or both aren't granted, run the following script. 
      USE MASTER;
GRANT CONNECT SQL, VIEW SERVER STATE TO CreativeSolutionsPracticeCsDatabaseOwner;
    4. There is sufficient RAM available on both the workstation and the server.
  3. After verifying these items, select
    Help
    , then
    Update Statistics
      to manually update the statistics in the database.

This article applies to:

  • Product: Accounting CS
  • Subject: Install,Setup,SQL