SQL-DMO
EnumMatchingSPs Method
The EnumMatchingSPs method returns a QueryResults object that enumerates the stored procedures that contain the specified search text.
Applies To
| Database Object |
Syntax
object.EnumMatchingSPs( Text , [ IncSys ] ) as QueryResults
Parts
object
Expression that evaluates to an object in the Applies To list
Text
String that specifies search text
IncSys
TRUE or FALSE
Prototype (C/C++)
HRESULT EnumMatchingSPs(
LPCOLESTR Text,
LPSQLDMOQUERYRESULTS * ppResults,
BOOL IncSys CPPDEFAULT (= FALSE));
Returns
A QueryResults object that contains one result set defined by this column.
| Column | Data type | Description |
|---|---|---|
| name | nchar(129) | Name of the stored procedure |
Remarks
When IncSys is TRUE, system and user-defined stored procedures are enumerated in the QueryResults object.
When IncSys is FALSE (default), only user-defined stored procedures are enumerated in the QueryResults object.