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_MSsetconflictscript(nvarchar @publication, nvarchar @article
, nvarchar @conflict_script
, nvarchar @login
, nvarchar @password)
MetaData:
-- Add the conflict script pointer to dbo.sysmergearticles - Used by snapshot --
create procedure sys.sp_MSsetconflictscript (
@publication sysname,
@article sysname,
@conflict_script nvarchar(255),
@login sysname =NULL,
@password nvarchar(524) =NULL
) AS
declare @artid uniqueidentifier
declare @pubid uniqueidentifier
--
-- Check for publish permission.
--
declare @retcode int
exec @retcode=sys.sp_MSreplcheck_publish
if @retcode<>0 or @@ERROR<>0 return (1)
select @pubid = pubid from dbo.sysmergepublications where name = @publication and UPPER(publisher)=UPPER(publishingservername()) and publisher_db=db_name()
if @pubid IS NULL
BEGIN
RAISERROR (20026, 16, -1, @publication)
RETURN (1)
END
select @artid = artid FROM dbo.sysmergearticles WHERE name = @article AND pubid = @pubid
if @artid IS NULL
BEGIN
RAISERROR (20027, 16, -1, @article)
RETURN (1)
END
update dbo.sysmergearticles set conflict_script = @conflict_script where artid = @artid and pubid=@pubid
if @@ERROR <> 0
return (1)
return (0)
No comments:
Post a Comment