Rebuilding Stored Procedures and Triggers - Intergraph Smart Instrumentation - 13.1 - Administration & Configuration - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Configuration and Maintenance Guide

English (United States)
Intergraph Smart Instrumentation
Search by Category
Administration & Configuration
Smart Instrumentation Version

This procedure allows you to identify abnormal database behavior and correct it by rebuilding the stored procedures and triggers in the database.  Stored procedures and triggers are portions of code that run automatically when you perform certain actions that affect the database.  For example, when you delete a loop, there is a stored procedure that runs to delete an associated loop drawing.  You can re-create stored procedures either for the Admin schema or for the Domain schema.

The System Administrator should perform this procedure if inappropriate SQL error messages are displayed in Smart Instrumentation.

Normally, you should run this option from the Administration module; however, you can run it from the Internal Setup Utility if for some reason you cannot log on to the Administration module.