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_helpallowmerge_publication()MetaData:
create procedure sys.sp_helpallowmerge_publication AS declare @db_name sysname declare @retcode int select @db_name = db_name() exec @retcode = sys.sp_MSreplcheck_publish if @@error <> 0 or @retcode <> 0 begin return (1) end if object_id('sysmergesubscriptions') is not NULL begin if exists (select priority from dbo.sysmergesubscriptions where db_name=@db_name and UPPER(subscriber_server) collate database_default = UPPER(publishingservername()) collate database_default and priority=0 and status <> 7) -- REPLICA_STATUS_BeforeRestore begin select 0 RETURN (0) end end select 1
No comments:
Post a Comment