SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
No columns were deselected or dropped.
Why is a replicated table marked as @vertical_partition = true when there is no partitioning?
Michael MacGregor
86
Reputation points
We have transactional replication and when I generated script to create or enable the components, I noticed that for just one table the @vertical_partition was set to True for sp_addarticle, followed by sp_articlecolumn calls for each of the columns in the table. There is no partitioning defined for the table so why is it doing this?
SQL 2019 SE 64bit CU9 running on an Azure VM
SQL Server | Other
4 answers
Sort by: Most helpful
-
CathyJi-MSFT 22,431 Reputation points Microsoft External Staff2021-08-30T09:00:26.49+00:00 Hi @Michael MacGregor ,
Did you drop/deselect one column from the article? Could you check in the article properties if there are columns which are deselected/not published?
Check if this similar thread could help you.
-
Michael MacGregor 86 Reputation points
2021-08-27T13:00:15.477+00:00 That doesn't help explain why it has been set in the generated script.
-
CathyJi-MSFT 22,431 Reputation points Microsoft External Staff
2021-08-27T07:12:37.007+00:00 Hi @Michael MacGregor ,
'@vertical_partition' enables or disables column filtering on a table article.
false indicates there is no vertical filtering and publishes all columns.
true clears all columns except the declared primary key, nullable columns with no default, and unique key columns. Columns are added using sp_articlecolumn.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.