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.

See Also

Reference

Database Class

EnumMatchingSPs Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Working with Database Objects

Creating, Altering, and Removing Stored Procedures

Creating, Altering, and Removing Databases

CREATE DATABASE (Transact-SQL)