Skip to content

DS Archive Support Website

Sections
Personal tools
You are here: Home » MAXIMO 4.1.1 Add-On Installation Guide » Installation for SQL Server Add-On

Installation for SQL Server Add-On

Using Query Analyzer, login as the DBO (or System Administrator), and execute the supplied TSQL Scripts in the following order:

  1. dsutility.tsql
  2. equipment.tsql
  3. inventory.tsql
  4. workorder.tsql
  5. workplans.tsql
  6. tooltrans.tsql
  7. ds_permissions.tsql
  8. ds_add_users.tsql

Example for loading and compiling the dsutility.tsql script file:

  1. Open the dsutility.tsql file.

Open Query File

2. Click the Run button Run Button to execute the TSQL script. The first time executing the script files, it is normal to encounter Can Not Drop Object errors.

Script Error

These errors occur because the scripts have been setup to drop objects before they are recreated. Since it is the first time running the scripts, there aren't any objects to initially drop. When you run it again, it should complete successfully.

Query

 

Created by root
Last modified 2004-09-22 09:37 AM
 

Powered by Plone

This site conforms to the following standards: