We have an existing table in 3 different publications (going to 3 different subscribers), 1 of those publications does not publish all columns.
All of these are transactional pull subscriptions.
I now need to add some more columns onto this table and we want to add them on to just the first two publications. However from MSDN:
[ @publication_to_add =] 'publication_to_add' Is the name of the publication to which the new column is added. publication_to_add is nvarchar(4000), with a default of ALL. If ALL, then all publications containing this table are affected. If publication_to_add is specified, then only this publication has the new column added.
which implies that it you expects it to specify 1 publication or ALL publications.
A sample table/publication detail to help demonstrate the issue:
[MyTable] ( ID int IDENTITY(1,1) NOT NULL, myName varchar(50) NULL, myDOB datetime, myJob varchar(100), mySpouseID int )
[InternalPublication] All fields, sent to InternalAdmin system [Reporting] All fields, sent to Reporting/Datawarehouse system [External] sent to External accessable system, fields sent: (ID, myName, myDOB)
How do I add on:
[myMarriageDate] datetime NULL, [myDivorceDate] datetime NULL
and have it only added to the publications [InternalPublication] and [Reporting]?
Note: sample is a made up one to protect the innocent