StoredProcInfo Table

The following table contains information used by the Report preparation DTS task to run stored procedures. This table should be updated when stored procedures needed for reporting are added or deleted.

Attribute name Data type Constraint Default Description
Name nvarchar (150) NULL None 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 If True (1), the stored procedure will be processed. If False (0), the procedure will not be processed.

Copyright © 2005 Microsoft Corporation.
All rights reserved.