create procedure sys.sp_MScreate_zero_identity_constraint
@subid uniqueidentifier
as
declare @retcode int
declare @artid uniqueidentifier
declare @qualified_table_name nvarchar(517)
-- change the constraints for identity range managed articles to be such that inserts are not allowed
declare Carticles CURSOR LOCAL FAST_FORWARD FOR
select artid from dbo.MSmerge_identity_range where subid = @subid
FOR READ ONLY
OPEN Carticles
FETCH Carticles INTO @artid
WHILE (@@fetch_status <> -1)
begin
select @qualified_table_name = sys.fn_MSmerge_getqualifiedobjname(@artid)
if @qualified_table_name is not NULL
begin
exec @retcode = sys.sp_MSrefresh_idrange_check_constraint
@qualified_table_name,
@artid,
0,
0,
0,
0
if @@error<>0 or @retcode<>0
begin
close Carticles
deallocate Carticles
goto Cleanup
end
end
fetch Carticles into @artid
end
close Carticles
deallocate Carticles
return 0
Cleanup:
return 1