The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_MSsub_set_identity(int @objid, int @threshold
, bigint @range
, bigint @next_seed)
MetaData:
create procedure sys.sp_MSsub_set_identity
@objid int,
@threshold int,
@range bigint,
@next_seed bigint
as
declare @retcode int
-- Security Check
EXEC @retcode = sys.sp_MSreplcheck_subscribe
IF @@ERROR <> 0 or @retcode <> 0
RETURN(1)
-- Stored last_seed in @next_seed
select @next_seed = @next_seed - @range
update MSsub_identity_range set
last_seed = @next_seed,
threshold = @threshold,
range = @range
where objid = @objid
IF @@ERROR <> 0
return 1
-- RESEED and change constraint
exec @retcode = sys.sp_MSreseed
@objid = @objid,
@next_seed = @next_seed,
@range = @range,
@is_publisher = -1
IF @@ERROR <> 0 OR @retcode <> 0
return 1
No comments:
Post a Comment