The StoredProcedures collection contains StoredProcedure objects referencing the system and user-defined stored procedures of a Microsoft® SQL Server™ database.
With the StoredProcedures collection, you can:
For more information about creating stored procedures by using the StoredProcedure object and StoredProcedures collection, see StoredProcedure Object.
To remove a stored procedure
Set oStoredProcedure = _
oDatabase.StoredProcedures("[Sales By Year]", "dbo")
When using the Item or Remove method, the StoredProcedures collection supports member identification using either name or ordinal reference syntax. For example:
Set oStoredProcedure = _
oDatabase.StoredProcedures("[Ten Most Expensive Products]")
Or:
Set oStoredProcedure = oDatabase.StoredProcedures(1)
Additionally, when using name-based item selection, the Item method allows owner name qualification of the targeted SQL Server stored procedure as shown earlier. When using the Remove method, the StoredProcedures collection does not support qualification of targeted object by owner name. It is suggested that you use the Item method to extract the target, then use the Remove method of the StoredProcedure object to drop a stored procedure.
Note Creating or removing SQL Server stored procedures by using the StoredProcedures collection requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the fixed role db_ddladmin or a role with greater privilege.
Add Method | Refresh Method |
Item Method | Remove Method (Collections) |
ItemByID Method |