Share via

  • Article

ReplicationStoredProcedures Collection

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The ReplicationStoredProcedures collection contains ReplicationStoredProcedure objects that reference the user-defined stored procedures of a Microsoft SQL Server database.

Modèle objet SQL-DMO qui affiche l'objet en cours

Properties

Count Property

Notes

SQL Server replication publications and subscriptions can be used to automate replication of user data. To simplify replication configuration when using SQL Distributed Management Objects (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")