Hi!
I'd like to publish two publications, both of them have got the same articles. That is all working fine.
But what when I'd like to make an article download only in the one publication and writeable in the other If I change the status (downloadable only) in one publication, it's automaticaly also altered in the other publication...
I would be glad, if someone could help me!
Same article in different Publications
Hot Topic
- Package Configuration in SQL
- a generic error occurred in gdi+
- SET IDENTITY_INSERT
- [DTS.Pipeline] Warning: The output column "Column 5" (1038) on output "Flat File Source Output" (2) and component "Flat File Sou
- Group headers are randomly disappearing on rpts
- SQL Server 2005 takes longer time to cancel a query
- PrimeOutput : difference between 'Output' and 'output buffer'
- TSQL for permissions script ?
- SQL Network Interfaces, error: 26 - Error
- variables in sql command
SQL Server
- Control Flow setup
- Replication Error
- Lookup transform not finding blank match
- Query 2 tables - each in a different database
- Search with %t%y% => Error, %ty% => ok...
- Privileges for Deploying Reports
- Variables Not Seen In Custom DataFlow Destination
- MDX - how to descend to dimension key level elements in a hierarchy which has not the key level in it
- cant access report manager options
- Need Bulk Insert help
Same article in different Publications
Elizabeth Bradley
Articles published in 2 different publications need to have the same value for this setting (downloadonly)
Please see BOL topics: "Publishing Data and Database Objects" and "sp_addmergearticle (Transact-SQL)"
Publishing Data and Database Objects
If an article is published in more than one merge publication, the following properties must have the same value for the article across all publications:
Column tracking
@column_tracking
Schema options
@schema_option
Column filtering
@vertical_partition
Subscriber upload options
@subscriber_upload_options
Conditional delete tracking
@delete_tracking
Error compensation
@compensate_for_errors
Identity range management
@auto_identity_range (deprecated) and @identityrangemangementoption
Publisher identity range
@pub_identity_range
Identity range
@identity_range
Identity range threshold
@threshold
Partition options
@partition_options
Blob column streaming
@stream_blob_columns
Filter type
@filter_type (parameter in sp_addmergefilter)
[ @subscriber_upload_options = ] subscriber_upload_options
Defines restrictions on updates made at a Subscriber with a client subscription. For more information, see < XML:NAMESPACE PREFIX = MSHelp NS = "http://msdn.microsoft.com/mshelp" />Optimizing Merge Replication Performance with Download-Only Articles . subscriber_upload_options is tinyint, and can be one of the following values.
0 (default)
No restrictions. Changes made at the Subscriber are uploaded to the Publisher.
1
Changes are allowed at the Subscriber, but they are not uploaded to the Publisher.
2
Changes are not allowed at the Subscriber.