Database configuration from the Management Studio

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

   

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 a Windows Explorer, 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_AgentJob_To_Enable_Broker.sql’ to the management studio and run this script.