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:
- dsutility.tsql
- equipment.tsql
- inventory.tsql
- workorder.tsql
- workplans.tsql
- tooltrans.tsql
- ds_permissions.tsql
- ds_add_users.tsql
Example for loading and compiling the dsutility.tsql script file:
- Open the dsutility.tsql file.
to execute the TSQL script.
The first time executing the script files, it is normal to encounter
Can Not Drop Object errors.
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.