May 14, 2012

sp_MSenumreplicas90 (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_MSenumreplicas90()

MetaData:

   
create procedure sys.sp_MSenumreplicas90
as
declare @inactive tinyint

-- Security check
declare @retcode int
exec @retcode = sys.sp_MSrepl_PAL_rolecheck
if (@retcode <> 0) or (@@error <> 0)
return 1

select @inactive = 0
if object_id('sysmergesubscriptions') is NULL
begin
RAISERROR(20054 , 16, -1)
return (1)
end

select subs.subid, subs.replnickname,
subs.subscriber_type, subs.subscription_type,
subs.priority, subs.schemaversion, subs.schemaguid, subs.datasource_type, NULL, subs.subscriber_server,
subs.db_name, subs.status, subs.replicastate, subs.sync_type, subs.description, subs.pubid, pubs.name, pubs.distributor,
subs.replica_version
from dbo.sysmergesubscriptions subs
left outer join dbo.sysmergepublications pubs
on subs.subid = pubs.pubid
where subs.status <> @inactive
and subs.subscriber_type = 1
order by convert(binary, subs.subid)
IF @@ERROR <>0 return (1)
return (0)

No comments:

Post a Comment

Total Pageviews