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