Database.ExtendedStoredProcedures Database.ExtendedStoredProcedures Database.ExtendedStoredProcedures Property

Definition

Gets a collection of ExtendedStoredProcedure objects. Each ExtendedStoredProcedure object represents an extended stored procedure defined on the database.

public:
 property Microsoft::SqlServer::Management::Smo::ExtendedStoredProcedureCollection ^ ExtendedStoredProcedures { Microsoft::SqlServer::Management::Smo::ExtendedStoredProcedureCollection ^ get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObject(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcContainerRelationship.ObjectContainer, Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcContainerCardinality.ZeroToAny, typeof(Microsoft.SqlServer.Management.Smo.ExtendedStoredProcedure))]
public Microsoft.SqlServer.Management.Smo.ExtendedStoredProcedureCollection ExtendedStoredProcedures { get; }
Public ReadOnly Property ExtendedStoredProcedures As ExtendedStoredProcedureCollection
Property Value

An ExtendedStoredProcedureCollection object that represents all the extended stored procedures defined on the database.

Examples

VB

'Connect to the local, default instance of SQL Server.  
Dim srv As Server  
srv = New Server  

'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  

'Display all the extended stored procedures in the database.  
Dim esp As ExtendedStoredProcedure  
For Each esp In db.ExtendedStoredProcedures  
   Console.WriteLine(esp.Name)  
Next  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  

Foreach ($esp in $db.ExtendedStoredProcedures)  
{  
   Write-Host $esp.Name  
}  

Remarks

Specific extended stored procedures can be referenced by using this collection by specifying the name of the stored procedure. To add a new extended stored procedure to the collection, call the extended stored procedure constructor ExtendedStoredProcedure.

Applies to