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 UrnCollection EnumMatchingSPs(
	string 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.

Return to top