Database.EnumMatchingSPs Method (String, Boolean)
Enumerates a list of stored procedures that contain the specified string in the definition.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function EnumMatchingSPs ( _
description As String, _
includeSystem As Boolean _
) As UrnCollection
'Usage
Dim instance As Database
Dim description As String
Dim includeSystem As Boolean
Dim returnValue As UrnCollection
returnValue = instance.EnumMatchingSPs(description, _
includeSystem)
public UrnCollection EnumMatchingSPs(
string description,
bool includeSystem
)
public:
UrnCollection^ EnumMatchingSPs(
String^ description,
bool includeSystem
)
member EnumMatchingSPs :
description:string *
includeSystem:bool -> UrnCollection
public function EnumMatchingSPs(
description : String,
includeSystem : boolean
) : UrnCollection
Parameters
- description
Type: System.String
A String value that specifies the text to find a match for in the stored procedure definition.
- includeSystem
Type: System.Boolean
A Boolean value that specifies whether to include system stored procedures in the returned list.
If True, system stored procedures are included. Otherwise, False.
Return Value
Type: Microsoft.SqlServer.Management.Smo.UrnCollection
A UrnCollection object value that contains a list of matching stored procedures for the database.