Symptoms

When adTempus is installed using the default SQL Server Express database engine, you may see frequent informational messages in the Application log in the Event Viewer with source MSSQL$ADTEMPUS and event ID 17137, reading "Starting up database 'adtempus_computername'."

Cause

This occurs if the adTempus database has the auto-close option set, which causes SQL Server to close the database whenever adTempus is not actively using it, and then reopen the database each when adTempus requests a new connection. Each time this happens, SQL Server logs the message. This situation may also reduce the performance of adTempus.

Resolution

To resolve this problem, update the adTempus database to turn off the auto-close option.

To do this, start the adtdbutil tool found in the adTempus program directory (see article K00000385 for more information). After the tool starts and connects to the database, enter the following command into the query panel:

alter database [databasename] set auto_close off

Replace databasename with the name of the adTempus database, which is shown in the Event Log message.

Press F5 to execute the command.