Define Global Database Options

Use the Database Options page in the CSM Administrator Blueprint Options window (accessed from within the Blueprint Editor) to define global general database options, inlcuding:

• Database timeout values: How long the database attempts to complete an operation before giving up.
• Foreign Keys: Whether or not to enable/enforce Foreign Keys. Foreign Keys establish and enforce a link between tables in a relational database, and are required by SQL Reporting Services.

To define global database options:

1. Open the Blueprint Editor
2. From the Blueprint Editor menu bar, click Tools>Options.
3. Click the Database Options page.

4. Define Timeout values for the database:
   1. Database command timeout: Specify the number of seconds to attempt a database command before giving up.
   2. Schema command timeout: Specify the number of seconds to use before timing out on SQL Server DDL (Data Definition Language) commands (used to create and modify database tables in the underlying database).

      Note: Select the No Limit check box to indefinitely attempt to complete the operations.

5. Enable and define Foreign Key settings:
   Note: You must enable foreign keys in order to use SQL Reporting Services.
   1. Create Foreign Keys for Relationships: Select this check box to enable/create foreign keys.
   2. Not Enforced/Enforced: Select whether or not to enforce foreign keys.

6. Click OK.