Cheers, I got round this by setting the Auto value to Manual and then setting the pub range, ident range and threshold.

Heres the code, hopefully it will help someone else.

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