Database Settings

View information about the current database connection

The database tab of the system administration screen provides details and statistics about the current state of the HelpMaster database.  This screen provides details about the following :

Database Details

This section displays the database connection, as well as the current database schema version.

The database connection string will have the following parts:

Setting Meaning
Data source= This is the name of the SQL Server
Initial catalog= This is the name of your HelpMaster database
Integrated security=SSPI If this is present, then it means that Windows Authentication is being used
User Id= If using SQL Server security, this is the user name
Password= If using SQL Server security, this is the password (obfuscated)

There may be other parts to the connection string depending on how the initial connection was configured. See Connecting to a HelpMaster database

Job Numbers

  • How many jobs have been logged, including the next number of the job to be logged

Change next Job number button: Click this to enter a job that that must be HIGHER than the current number.

Reset Job numbers: Click this button to reset the job numbering back to the next highest job number available - as determined by the current highest job number that has already been logged. This button really only has context if you use the “Change next Job number” button above it, and set the next job number to something higher, and then wish to revert that change.

Database maintenance

After upgrading a database, or after creating new system codes for contact details or custom fields, HelpMaster needs to update certain database objects in order to effect the change.   This process normally occurs automatically.  The “Run database maintenance” button is provided on this screen to allow system administrators to manually run this process if required.

Clicking this button runs the database stored procedure called “stpDatabaseMaintenance_Master".  This can also be run directly from SQL Server.

In order for this stored procedure to run correctly, the user must have sufficient database permissions.

Note! This button triggers an internal HelpMaster database maintenance process which is different from the regular Microsoft SQL Server Database Maintenance that should be performed regularly. See Database maintenance for details about this.

database maintenance

Execute Custom SQL

Use this textbox to paste or enter SQL.  When you click “Execute SQL”, whatever you have entered will be executed against your HelpMaster database. Use the Validate SQL button to ensure that your SQL syntax is correct.  This feature is intended to be used as a quick way to directly manipulate your HelpMaster database, without having to have Microsoft SQL Server Management Studio or similar tools installed on your system.  Occasionally, HelpMaster support may direct you to use this feature.

Use this feature with the utmost caution and knowledge.  There is no undo with SQL.  Only experienced SQL Database administrators should use this feature.  It is highly recommended that you make a full backup of your database before using this feature.

See Also

Database maintenance

Database growth

Database and Reports Wizard