ReplicationStoredProcedures Collection (SQL-DMO)

The ReplicationStoredProcedures collection contains ReplicationStoredProcedure objects referencing the user-defined stored procedures of a Microsoft® SQL Server™ database.

Remarks

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")

Methods
Item Method  

Properties

Count Property

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.