April 25, 2012

sp_getqueuedarticlesynctraninfo (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_getqueuedarticlesynctraninfo(nvarchar @publication
, int @artid)

MetaData:

 create procedure sys.sp_getqueuedarticlesynctraninfo   
(
@publication sysname -- publication - cannot be null
,@artid int -- article id - cannot be null
)
as
begin
set nocount on
declare @retcode int
,@owner sysname
,@synctraninsproc sysname
,@synctranupdproc sysname
,@synctrandelproc sysname
,@cftprocname sysname
,@articlename sysname
,@tablename sysname
--
-- security check - should be dbo or sysadmin
--
exec @retcode = sp_MSreplcheck_publish
if @@error != 0 or @retcode != 0
return 1
if (object_id(N'dbo.sysarticleupdates') is null
or object_id(N'dbo.syspublications') is null)
return 1
--
-- get the information needed for resultset
--
select schema_name(objectproperty(a.sync_ins_proc, 'SchemaId'))
,object_name(a.sync_ins_proc)
,object_name(a.sync_upd_proc)
,object_name(a.sync_del_proc)
,object_name(a.ins_conflict_proc)
,art.name
,object_name(art.objid)
from dbo.syspublications p
join dbo.sysarticles as art on p.pubid = art.pubid
join dbo.sysarticleupdates as a on art.artid = a.artid
where art.artid = @artid
and p.name = @publication
--
-- all done
--
return 0
end

No comments:

Post a Comment

Total Pageviews