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
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
Creating, Altering, and Removing Stored Procedures