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