StoredProcedureCollection.Item Property (String, String)

Gets a StoredProcedure object in the collection by name and schema.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public ReadOnly Default Property Item ( _
    name As String, _
    schema As String _
) As StoredProcedure 
    Get
'Usage
Dim instance As StoredProcedureCollection 
Dim name As String 
Dim schema As String 
Dim value As StoredProcedure 

value = instance(name, schema)

public StoredProcedure this[
    string name,
    string schema
] { get; }

public:
property StoredProcedure^ default[String^ name, String^ schema] {
    StoredProcedure^ get (String^ name, String^ schema);
}

member Item : StoredProcedure

JScript supports the use of indexed properties, but not the declaration of new ones.

Parameters

• name
  Type: System.String
  A String value that specifies the name of the StoredProcedure object in the StoredProcedureCollection collection.

• schema
  Type: System.String
  A String value that specifies the name of the schema.

Property Value

Type: Microsoft.SqlServer.Management.Smo.StoredProcedure
A StoredProcedure object value that represents the stored procedure.

Examples

Using Collections

See Also

Reference

StoredProcedureCollection Class

Item Overload

Microsoft.SqlServer.Management.Smo Namespace