March 10, 2017 at 7:58 am
I have a publisher with 300+ articles being pushed (1-way trans). The db has way more tables than that, but we only replicate some. I'm trying to write a query that will list the tables being replicated and whether or not their indexes are being replicated. I'm hung up on the indexes. What table/sproc/function do I need to add to the following to pull that in:
SELECT P.[publication] AS [Publication Name]
,A.[publisher_db] AS [Database Name]
,A.[article] AS [Article Name]
,A.[source_owner] AS [Schema]
,A.[source_object] AS [Table]
FROM [distribution].[dbo].[MSarticles] AS A
INNER JOIN [distribution].[dbo].[MSpublications] AS P
ON (A.[publication_id] = P.[publication_id])ORDER BY P.[publication], A.[article];
March 14, 2017 at 7:25 am
Nobody is replying, so I'm adding this to a different topic
March 14, 2017 at 9:02 am
query dbo.sysarticles on the published database ad the schema option column has a bitmap of what is replicated for each object
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2017 at 9:30 am
There's nothing in that table that indicates whether or not an article's indexes are set to replicate
March 14, 2017 at 9:31 am
robin.pryor - Tuesday, March 14, 2017 9:30 AMThere's nothing in that table that indicates whether or not an article's indexes are set to replicate
Nothing obvious anyway. Am I misreading the meaning of one of the columns maybe?
March 14, 2017 at 9:35 am
the schema option column is a bitmap and defines what is replicated
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply