The EnumMatchingSPs method returns a QueryResults object that enumerates the stored procedures that contain the specified search text.
object.EnumMatchingSPs( Text , [ IncSys ] ) as QueryResults
object
Expression that evaluates to an object in the Applies To list
Text
String that specifies search text
IncSys
TRUE or FALSE
HRESULT EnumMatchingSPs(
LPCOLESTR Text,
LPSQLDMOQUERYRESULTS * ppResults,
BOOL IncSys CPPDEFAULT (= FALSE));
A QueryResults object that contains one result set defined by this column.
| Column | Data type | Description |
|---|---|---|
| name | nchar(129) | Name of the stored procedure |
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.