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_MShelpmergeschemaarticles(nvarchar @publication)MetaData:
create procedure sys.sp_MShelpmergeschemaarticles
@publication sysname
as
begin
set nocount on
declare @pubid uniqueidentifier
declare @retcode int
if (@publication is null)
begin
raiserror(14003, 16, -1)
return (1)
end
if object_id('MSmerge_contents') is NULL
begin
raiserror(20054, 16, -1)
return (1)
end
--
-- Security Check.
--
exec @retcode = sys.sp_MSmerge_validate_publication_presence @publication, NULL, NULL, @pubid output
if @retcode <> 0 or @@error <> 0
return 1
select a.name, o.name, SCHEMA_NAME(o.schema_id), a.destination_object, a.destination_owner, a.artid, @pubid, a.pre_creation_command, a.status, a.type
from dbo.sysmergeschemaarticles a
inner join sys.objects o
on a.objid = o.object_id
where pubid = @pubid
return 0
end
No comments:
Post a Comment