The IN_DB_UTIL_SP_GET_DB_INFO stored procedure will display configuration details and information about the database.
| Parameter | Description | |
|---|---|---|
| MODE | Type: | INPUT |
| Datatype: | NVARCHAR(8) | |
| Default Value: | BASIC | |
| Description | The mode determines the level of details and information to collect and display. | |
| Options |
BASIC = Displays the version of SQL Server and the database compatibility level, and the database collation and recovery model, as well as the inuser schema history DETAILED = Includes all the basic details as well as database files, database and instance parameters and database connection information |
|
| V_RETURN_VAL | Type: | OUTPUT |
| Datatype: | INTEGER | |
| Default Value: | 0 | |
| Description | Specifies whether the execution of the procedure was successful or
not. 0 = Success 1 = Error |
|
Example
EXEC IN_GET_DB_INFO 'BASIC' EXEC IN_GET_DB_INFO 'DETAILED'