Querying and Updating the Database

The main screen of the Database Utility presents an empty box in which you can enter a SQL query or update statement.

Press F5 to execute each statement.

Never use this tool (or any other) to update the adTempus database except under the direction of support personnel. Doing so may result in irreversible corruption of your data.

The Database Utility automatically connects to the adTempus database. If adTempus uses Integrated (Windows) security, the utility can connect only if your Windows account has permission for the database; you may need to log in as an administrator or as the user who installed adTempus. The Database Utility is installed with the adTempus server and is not available in Console-only installations.

Using Other Query Tools

You can also query the database using SQL Server Management Studio or any other tool that is compatible with SQL Server. If you are using the SQL Server Express instance installed with adTempus, specify the server as "computername\ADTEMPUS", where computername is the name of the computer where adTempus is installed. To connect from a different computer, you must first enable remote connections for SQL Server Express.

If your version of Management Studio is older than the version of SQL Server you are connecting to, you may not be able to connect or perform some operations. Install a newer version of Management Studio in this case.