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