This topic has not yet been rated - Rate this topic

StoredProcedureCollection Class

SQL Server 2008

The StoredProcedureCollection class represents a collection of StoredProcedure objects that represent all the stored procedures that are defined on a table.

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

Syntax

C++

JScript

public sealed class StoredProcedureCollection : SchemaCollectionBase

Remarks

A StoredProcedureCollection object can be used to gain access to a set of stored procedures. You can use the Item() property to return a specific StoredProcedure object.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Examples

Using Collections

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.AbstractCollectionBase
    Microsoft.SqlServer.Management.Smo.SmoCollectionBase
      Microsoft.SqlServer.Management.Smo.SortedListCollectionBase
        Microsoft.SqlServer.Management.Smo.SchemaCollectionBase
          Microsoft.SqlServer.Management.Smo.StoredProcedureCollection

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Reference

StoredProcedureCollection Members

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD