The EnumMatchingSPs method returns a QueryResults object enumerating the stored procedures containing the specified search text.
object.EnumMatchingSPs( Text , [ IncSys ] ) as QueryResults
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| Text | String specifying search text |
| IncSys | True or False |
A QueryResults object containing 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.
HRESULT EnumMatchingSPs(
LPCOLESTR Text,
LPSQLDMOQUERYRESULTS * ppResults,
BOOL IncSys CPPDEFAULT (= FALSE));