Previous Topic

Next Topic

Inhoudsopgave

Book Index
Database configuration from the Management Studio

Note: You can use all characters in a database name, except ", ' and [ ].

  1. Click Databases, click System Databases, then right click model and then click Properties.
  2. Click Options on the left-hand pane.
  3. Change ANSI NULLS Enabled, ANSI Padding Enabled, Arithmetic Abort Enabled, Concatenate Null Yields Null, Quoted Identifiers Enabled, and Recursive Triggers Enabled to ‘True’. The total set of options should be as shown below. Then click OK.

    Database Properties

  4. Click Databases, click System Databases, then right click tempdb and then click Properties.
  5. Click Options on the left-hand pane. Change Arithmetic Abort Enabled to ‘True’.
  6. Click Databases, click System Databases, then right click model and then click Properties. Open your browser, go to ‘\IsahSetup_5_1_Isah\[UPDATEPACKNO]_[VERSIONNO]\Server_Software\MSSQL_DBServer_Scripts’ and drag the script ‘_AddUDT.sql’ to the Management Studio. Run the script by clicking ‘<CTRL> E’.
  7. From ‘\IsahSetup_[RELEASENO e.g. 5_1]_Isah\[UPDATEPACKNO]_[VERSIONNO]\Server_Software\MSSQL_DBServer_Scripts’, drag the script ‘_AddLogins.sql’ to the management studio and run this script.
  8. From ‘\IsahSetup_5_1_Isah\[UPDATEPACKNO]_[VERSIONNO]\Server_Software\MSSQL_DBServer_Scripts’, drag the script ‘_Create_Isah_Standard_AgentJobs.sql’ to the management studio and run this script.