- Adding article 1 of 1 (Error)
Messages
SQL Server Management Studio could not create article 'Table1'. (New Publication Wizard)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Automatic identity range support is useful only for publications that allow updating subscribers.
Changed database context to 'DB1'. (Microsoft SQL Server, Error: 21231)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=21231&LinkId=20476
 

USE [DB]

CREATE TABLE #tempSysMergeArticles
(
	[tableName] [varchar](255) NOT NULL,
	[Row] [int] IDENTITY(1,1) NOT NULL
)

DECLARE @intLoop int
DECLARE @tableName varchar(255), @replication_publication varchar(255), @value_option varchar(255)
DECLARE @value_pub_identity_range int, @value_identity_range int, @value_threshold int

SET @replication_publication = 'DBMerge'
SET @value_pub_identity_range = 1000000
SET @value_identity_range = 2000
SET @value_threshold = 80
SET @value_option = 'manual'

INSERT INTO #tempSysMergeArticles
	( 
		[tableName]
	)
	(
		select [name]
		from dbo.sysmergearticles 
		WHERE [identity_support] = 1
	)

set @intLoop = 0
            while (@intLoop  < (SELECT MAX([Row]) FROM #tempSysMergeArticles))
            begin
				set @intLoop = @intLoop + 1		
				set @tableName = (SELECT [tableName] FROM #tempSysMergeArticles WHERE [Row] = @intLoop)

				exec sp_changemergearticle 
							@publication = @replication_publication, 
							@article = @tableName, 
							@property = N'pub_identity_range', 
							@value = @value_pub_identity_range, 
							@force_invalidate_snapshot = 1, 
							@force_reinit_subscription = 1

				exec sp_changemergearticle 
							@publication = @replication_publication, 
							@article = @tableName, 
							@property = N'identity_range', 
							@value = @value_identity_range, 
							@force_invalidate_snapshot = 1, 
							@force_reinit_subscription = 1

				exec sp_changemergearticle 
							@publication = @replication_publication, 
							@article = @tableName, 
							@property = N'threshold', 
							@value = @value_threshold, 
							@force_invalidate_snapshot = 1, 
							@force_reinit_subscription = 1				
							
				exec sp_changemergearticle 
							@publication = @replication_publication, 
							@article = @tableName, 
							@property = N'identityrangemanagementoption', 
							@value = @value_option, 
							@force_invalidate_snapshot = 1, 
							@force_reinit_subscription = 1

            end -- while loop

DROP TABLE #tempSysMergeArticles