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_MSconflicttableexists(uniqueidentifier @pubid, uniqueidentifier @artid)
MetaData:
create procedure sys.sp_MSconflicttableexists @pubid uniqueidentifier, @artid uniqueidentifier, @exists int output as declare @retcode int declare @tablename sysname declare @ownername sysname declare @qualified_tablename nvarchar(270) EXEC @retcode = dbo.sp_MSreplcheck_subscribe if @@ERROR <> 0 or @retcode <> 0 return(1) set @exists= 0 select top 1 @tablename= conflict_table, @ownername= destination_owner from dbo.sysmergearticles where pubid=@pubid and artid=@artid if @@error<>0 return 1 if @tablename is not null begin if @ownername is null begin set @qualified_tablename= quotename(@tablename) end else begin set @qualified_tablename= quotename(@ownername) + '.' + quotename(@tablename) end if object_id(@qualified_tablename) is not null begin set @exists= 1 end end return 0
No comments:
Post a Comment