Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Update

Update database statistics

Database statistics are used to ensure that your database is providing data to
Workpapers 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.

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 to
    SQL Server and Windows Authentication mode
     for your SQL Server instance.
  • The database owner login CreativeSolutionsPracticeCsDatabaseOwner exists
  • The database owner login CreativeSolutionsPracticeCsDatabaseOwner has the proper permissions. Grant permission is required for
    Connect SQL
     and
    View 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.

This article applies to:

  • Product: Workpapers CS
  • Subject: Install, Setup