May 8, 2012

sp_MSchangearticleresolver (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_MSchangearticleresolver(nvarchar @article_resolver
, nvarchar @resolver_clsid
, uniqueidentifier @artid
, nvarchar @resolver_info)

MetaData:

   
create procedure sys.sp_MSchangearticleresolver (
@article_resolver nvarchar(255),
@resolver_clsid nvarchar(40),
@artid uniqueidentifier,
@resolver_info nvarchar(517) = NULL
)
as
declare @retcode int
-- Security check: dbo and sysadmin only
exec @retcode = sys.sp_MSreplcheck_publish
if @@error <> 0 or @retcode <> 0
begin
return 1
end

if (@resolver_clsid='') select @resolver_clsid = NULL
UPDATE dbo.sysmergearticles
SET article_resolver = @article_resolver, resolver_clsid = @resolver_clsid, resolver_info = @resolver_info
WHERE artid = @artid
if @@ERROR <> 0
RETURN (1)
return (0)

No comments:

Post a Comment

Total Pageviews