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)

Syntax

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

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

Parameters

  • 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.

Remarks

The stored procedure is defined in the TextBody property.