Share via


StoredProcInfo Table

The following table contains information that the Report preparation DTS task uses to run stored procedures. Update this table when you add or delete stored procedures that you use for reporting.

Attribute name

Data type

Constraint

Default

Description

Name

nvarchar (150)

NULL

None

Contains the name of the stored procedure.

Ordinal

int

NULL

None

Specifies the order in which the stored procedure will be processed by the Report preparation DTS task.

ProcessingEnabled

bit

NULL

1

Specifies whether the stored procedure will be processed. If True (1), the procedure will be processed. If False (0), the procedure will not be processed.

See Also

Other Resources

Data Warehouse Report Tables