Database.EnumMatchingSPs Method (String)

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)


Public Function EnumMatchingSPs ( _
    description As String _
) As UrnCollection
Dim instance As Database
Dim description As String
Dim returnValue As UrnCollection

returnValue = instance.EnumMatchingSPs(description)
public UrnCollection EnumMatchingSPs(
    string description
UrnCollection^ EnumMatchingSPs(
    String^ description
member EnumMatchingSPs : 
        description:string -> UrnCollection 
public function EnumMatchingSPs(
    description : String
) : UrnCollection


  • description
    Type: System.String
    A String value that specifies the text to find a match for in the stored procedure definition.

Return Value

Type: Microsoft.SqlServer.Management.Smo.UrnCollection
A UrnCollection object value that contains a list of matching stored procedures for the database.


The stored procedure is defined in the TextBody property.