question

user-470 avatar image
user-470 asked

How to query synchronization status for push transactional replication

I have a transactional push-only publication/subscription in SQL Server 2005 that I am creating with a script. The synchronization schedule is set to continuous.

As part of the setup for the subscriber, I need to wait until after the initial synchronization has completed and then perform additional setup of the database.

How can I query to see if the initial synchronization has completed?

sql-server-2005replication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Blackhawk-17 avatar image
Blackhawk-17 answered

Is not Replication Monitor providing you with this information?

If not you can search BOL for sp_replmonitorhelpsubscription.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

If not you can search BOL for avatar image
If not you can search BOL for answered

If not you can search BOL for sp_replmonitorhelpsubscription.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.