Database Diagnostics SP

Report Name: Database Diagnostics SP_HELP (example)

File Name: EarthSoft.Reports.Library.21633.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

Description: The Database Diagnostics Report provides information on the owner, type and CREATED_DATETIME of a selected object or the name, owner, and type of all objects in the database if you do not select a specific object.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview:

To run this report, select one database Object from the tables list.

Source Tables SYS.ALL_OBJECTS, MASTER.DBO.SPT_VALUES, SYS.TYPES, SYS.ALL_COLUMNS, SYS.COLUMNS, SYS.ALL_PARAMETERS, SYSDEPENDS, SYS.IDENTITY_COLUMNS

Report Parameters

Object Name

Report Output
Sheet 1: Name Owner Type Created_datetime Sheet 2: Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation	Sheet 3: Identity Seed Increment Not For Replication Sheet 4: RowGuidCol Sheet 5: Data_located_on_filegroup Sheet 6: index_name index_description index_keys	Sheet 7: constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys Sheet 8: Table is referenced by foreign key

Report Output

Sheet 1:

Name

Owner

Type

Created_datetime

Sheet 2:

Column_name

Type

Computed

Length

Prec

Scale

Nullable

TrimTrailingBlanks

FixedLenNullInSource

Collation

Sheet 3:

Identity

Seed

Increment

Not For Replication

Sheet 4:

RowGuidCol

Sheet 5:

Data_located_on_filegroup

Sheet 6:

index_name

index_description

index_keys

Sheet 7:

constraint_type

constraint_name

delete_action

update_action

status_enabled

status_for_replication

constraint_keys

Sheet 8:

Table is referenced by foreign key

1Excel report output requires a valid license of Microsoft Excel to view the output.