question

kimchompy avatar image
kimchompy asked

List All Indexes currently being replicated

Does anybody know how to generate a list of all indexes that are currently being replicated. Im trying to automate the checking of when replication has been delivered for a specific publication (the last part is when it creates indexes).
replicationindexessql2012
2 comments
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.

kimchompy avatar image kimchompy commented ·
i started by using the snapshot history table to look for the Delivered Snapshot message - but because indexes are created after the snapshot is delivered (and on our system can take up to one hour to be created) - i couldnt use this table. i need to look for when indexes are created - as i have to start some SQL Jobs after replication has been delivered
0 Likes 0 ·
kimchompy avatar image kimchompy commented ·
its sql 2012 Enterprise Edition
0 Likes 0 ·

0 Answers

·

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.