Export (0) Print
Expand All

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)

'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)

Parameters

description
Type: 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.

Community Additions

ADD
Show:
© 2014 Microsoft