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_MSmerge_log_identity_range_allocations(nvarchar @publisher, nvarchar @publisher_db
, nvarchar @publication
, nvarchar @article
, nvarchar @subscriber
, nvarchar @subscriber_db
, bit @is_pub_range
, tinyint @ranges_allocated
, numeric @range_begin
, numeric @range_end
, numeric @next_range_begin
, numeric @next_range_end)
MetaData:
create procedure sys.sp_MSmerge_log_identity_range_allocations
(
@publisher sysname,
@publisher_db sysname,
@publication sysname,
@article sysname,
@subscriber sysname,
@subscriber_db sysname,
@is_pub_range bit,
@ranges_allocated tinyint,
@range_begin numeric(38,0),
@range_end numeric(38,0),
@next_range_begin numeric(38,0),
@next_range_end numeric(38,0)
)
as
set nocount on
declare @retcode tinyint
declare @max_used numeric(38,0)
declare @publisher_id int
--
-- security check
-- only db_owner can execute this
--
if (is_member ('db_owner') != 1)
begin
raiserror(14260, 16, -1)
return (1)
end
-- Has to be executed from distribution database
if sys.fn_MSrepl_isdistdb (db_name()) != 1
begin
raiserror (21482, 16, -1, 'sp_MSmerge_log_identity_range_allocation', 'distribution')
return 1
end
select @publisher_id = srvid
from master..sysservers
where upper(srvname) = upper(@publisher)
if @publisher_id is NULL
begin
-- Publisher @publisher does not exist.
raiserror(21618, 16, -1, @publisher)
return 1
end
-- we cannot allocate 0 ranges or call this proc with range_end begin NULL
if @ranges_allocated = 0 or @ranges_allocated is NULL or @range_end is NULL
begin
raiserror(20710, 16, -1, @publisher, @publisher_db, @publication, @article)
return 1
end
if @next_range_end is NULL
select @max_used = @range_end
else
select @max_used = @next_range_end
-- insert the passed in information into the table
insert into dbo.MSmerge_identity_range_allocations
(publisher_id, publisher_db, publication, article, subscriber, subscriber_db,
is_pub_range, ranges_allocated, range_begin, range_end, next_range_begin, next_range_end, max_used)
values
(@publisher_id, @publisher_db, @publication, @article, @subscriber, @subscriber_db,
@is_pub_range, @ranges_allocated, @range_begin, @range_end, @next_range_begin, @next_range_end, @max_used)
if @@error<>0
return 1
return 0
No comments:
Post a Comment