May 8, 2012

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

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

Total Pageviews