June 13, 2012

sp_validatemergesubscription (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


sys.sp_validatemergesubscription(nvarchar @publication
, nvarchar @subscriber
, nvarchar @subscriber_db
, tinyint @level)


create procedure sys.sp_validatemergesubscription
(@publication sysname,
@subscriber sysname,
@subscriber_db sysname,
@level tinyint
) AS

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

-- make sure current database is enabled for merge replication --
exec @retcode=sys.sp_MSCheckmergereplication
if @@ERROR<>0 or @retcode<>0
return (1)

select @pubid = pubid from dbo.sysmergepublications where name = @publication and UPPER(publisher)=UPPER(publishingservername()) and publisher_db=db_name()
if @pubid is NULL
raiserror (20026, 16, -1, @publication)
return (1)
if @level <1 or @level > 3
raiserror(21184, 16, -1, '@level', '1', '2','3')
return (1)

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

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