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. |