Handy Software Lab Products FAQ

This article applies to:

• HSLAB Print Logger
• HSLAB Access Control 
• SQL Express

Symptoms:

• The following event is logged to the Windows event viewer application log repeatedly (once a minute or more):
  
  Event Type: Information
  Event Source: MSSQLSERVER
  Event ID: 17137
  Description: Starting up database 'HSLAB_Print_Logger'.

Causes:

• This event is logged as a result of the database autoclose feature in SQL being turned on for the HSLAB_Print_Logger database.
• For more information on the SQL Auto-Close feature, see the following from MSDN:
  http://msdn2.microsoft.com/en-us/library/ms190249.aspx
  

Resolution:

Disable the autoclose feature for the HSLAB_Print_Logger database.

HSLAB recommends use of SQL Management Studio. A free "express" edition of this tool is available from Microsoft.

SQL Management Studio

1. Open SQL Management Studio and connect to the instance that hosts the HSLAB_Print_Logger database.
2. In the left pane expand Databases, right-click the HSLAB_Print_Logger database, and select Properties.
3. From the Properties window, select Options.
4. Under the heading Automatic, change  "Auto Close" from True to False.
5. Click OK to apply the change.

SQL Query

If you do not have SQL Management Studio installed, the same can be accomplished by running the following SQL query:

ALTER DATABASE [HSLAB_Print_Logger] SET AUTO_CLOSE OFF WITH NO_WAIT

• Replace "HSLAB_Print_Logger" in the above line with the appropriate name for your  database if you're using other software
  

Notes:

• The logged event is informational only and does not indicate an error. The default behavior in SQL Express is to enable autoclose for databases. This behavior allows database files to be manipulated outside the SQL framework. For HSLAB databases, disabling autoclose can improve performance.
• HSLAB intends to change the default autoclose setting for databases in a future release of Print Logger.