The ReplicationStoredProcedures collection contains ReplicationStoredProcedure objects referencing the user-defined stored procedures of a Microsoft® SQL Server™ database.
SQL Server replication publications and subscriptions can be used to automate replication of user data. To simplify replication configuration when using SQL-DMO, SQL-DMO implements the ReplicationTables and ReplicationStoredProcedures collections, which list user-defined tables and stored procedures.
With the ReplicationStoredProcedures collection, you can enumerate those stored procedures that can participate in transactional or merge replication as a source for article data.
When using the Item method, the ReplicationStoredProcedures collection supports member identification using either name or ordinal reference syntax. For example:
Set oReplicationStoredProcedure = _
oRepDb.oReplicationStoredProcedures("Inventory_Update")
Or:
Set oReplicationStoredProcedure = oRepDb.oReplicationStoredProcedures(1)
Additionally, when using the stored procedure name to select an object from the collection, the Item method allows owner name qualification. For example:
Set oReplicationStoredProcedure = _
oRepDb.oReplicationStoredProcedures("Inventory_Update", "dbo")
Item Method |