The IN_DB_UTIL_SP_CHECK_DEPENDENCIES stored procedure contains the list of all the IN_DB_UTIL objects and is used to validate that each defined object exists. Any missing dependencies will be printed in the Message tab.
The IN_DB_UTIL_SP_CHECK_DEPENDENCIES procedure is called when the IN_DB_UTIL_SP_SESSION_SETUP procedure is executed during session initialization.
| Parameter | Description | |
|---|---|---|
| DEBUG | Type: | INPUT |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display the procedure name during execution. | |
| Options | YES NO |
|
| V_RETURN_VAL | Type: | RETURN |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description | Specifies whether the execution of the procedure was successful or not. 0 = SUCCESS (All dependencies exist) 1 = ERROR (Missing Procedure or Function or Type or Synonym) |
|
Example
EXEC @V_CALL_RETURN = IN_CHECK_DEPENDENCIES @V_DEBUG; IF @V_CALL_RETURN = 1 BEGIN GOTO MISSING_DEPENDENCY; END; EXEC IN_CHECK_DEPENDENCIES 'YES'