May 16, 2012

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


sys.sp_MSgetpubinfo(nvarchar @publication
, nvarchar @publisher
, nvarchar @pubdb)


create procedure sys.sp_MSgetpubinfo (
@publication sysname, -- The publication name --
@publisher sysname,
@pubdb sysname
) AS


-- don't further qualify with server name and DB name - it's just security checking
declare @retcode int
exec @retcode = sys.sp_MSrepl_PAL_rolecheck
if (@retcode <> 0) or (@@error <> 0)
return 1

select pubid from dbo.sysmergepublications where name = @publication and
LOWER(publisher) = LOWER(@publisher) and LOWER(publisher_db) = LOWER(@pubdb)

No comments:

Post a Comment

Total Pageviews