June 13, 2012

sp_validatemergepullsubscription (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_validatemergepullsubscription(nvarchar @publication
, nvarchar @publisher
, nvarchar @publisher_db
, tinyint @level)

MetaData:

 create procedure sys.sp_validatemergepullsubscription  
(@publication sysname,
@publisher sysname,
@publisher_db sysname,
@level tinyint
) AS

set nocount on
declare @retcode int
declare @pubid uniqueidentifier
declare @subscriber sysname
declare @subscriber_db sysname
declare @subid uniqueidentifier
--
-- Security Check
--
EXEC @retcode = sys.sp_MSreplcheck_publish
IF @@ERROR <> 0 or @retcode <> 0
return (1)

select @subscriber = @@SERVERNAME, @subscriber_db=db_name()
select @pubid = NULL
select @subid = NULL

select @pubid=pubid from dbo.sysmergepublications where LOWER(publisher)=LOWER(@publisher) and publisher_db=@publisher_db and name=@publication
if @pubid is NULL
begin
raiserror (20026, 16, -1, @publication)
return (1)
end

if @level <0 or @level > 3
begin
raiserror(21184, 16, -1, '@level', '1', '2','3')
return (1)
end

select @subid = subid from dbo.sysmergesubscriptions where pubid=@pubid and db_name=@subscriber_db and LOWER(subscriber_server) = LOWER(@subscriber)
if @subid is NULL
begin
raiserror(14055, 16, -1)
return (1)
end

update dbo.MSmerge_replinfo
set validation_level=@level
where repid = @subid
if @@ERROR<>0
return (1)
return (0)

No comments:

Post a Comment

Total Pageviews