BugZero found this defect 67 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
3/14/2024
SQL Server 2022 on Linux
SQL Server 2022 on Windows
build lower than 16.0.4115.5
16.0.4115.5
Fixes the following errors that you encounter when using sp_addsubscription to create the Subscriber on secondary replicas if the distribution database is in an availability group: Msg 20032, Level 16, State 1, Procedure distribution.dbo.sp_MSadd_subscription, Line <LineNumber> [Batch Start Line 33] <SubscriberName> is not defined as a Subscriber for <PublisherName>. Msg 14070, Level 16, State 1, Procedure sys.sp_MSrepl_changesubstatus, Line <LineNumber> [Batch Start Line 33] Could not update the distribution database subscription table. The subscription status could not be changed. Msg 14057, Level 16, State 1, Procedure sys.sp_MSrepl_addsubscription_article, Line <LineNumber> [Batch Start Line 33] The subscription could not be created.