May 15, 2012

sp_MSget_subscriber_partition_id (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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_MSget_subscriber_partition_id(nvarchar @publication
, nvarchar @host_name_override
, nvarchar @suser_sname_override)

MetaData:

   
create procedure sys.sp_MSget_subscriber_partition_id (@publication sysname, @partition_id int OUTPUT, @maxgen_whenadded bigint OUTPUT, @host_name_override sysname = NULL, @suser_sname_override sysname = NULL)
as
begin
set nocount on

declare @partition_id_eval_proc nvarchar(270), @retcode int

exec @retcode = sys.sp_MSrepl_PAL_rolecheck @publication = @publication
if @retcode<>0 or @@ERROR<>0
return 1

select @partition_id_eval_proc = partition_id_eval_proc from dbo.sysmergepublications
where name = @publication and UPPER(publisher)=UPPER(publishingservername()) and publisher_db=db_name()

if @partition_id_eval_proc is not null
begin
select @partition_id_eval_proc = 'dbo.' + @partition_id_eval_proc

exec @retcode = @partition_id_eval_proc @partition_id OUTPUT,
@maxgen_whenadded OUTPUT,
@host_name_override,
@suser_sname_override

if @retcode <> 0 or @@error <> 0
return 1
end

return 0
end

No comments:

Post a Comment

Total Pageviews