May 24, 2012

sp_MSquerysubtype (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_MSquerysubtype(uniqueidentifier @pubid
, nvarchar @subscriber
, nvarchar @subscriber_db)


create procedure sys.sp_MSquerysubtype (@pubid uniqueidentifier,@subscriber sysname, @subscriber_db sysname)
-- Security check
if (1 <> {fn ISPALUSER(@pubid)} and
1 <> is_member('db_owner'))
RAISERROR (15247, 11, -1)
return (1)
declare @subtype int
declare @deleted int

set @deleted = 2

select @subtype = NULL
select @subtype = subscription_type from dbo.sysmergesubscriptions where pubid=@pubid
and db_name=@subscriber_db
and UPPER(subscriber_server) collate database_default = UPPER(@subscriber) collate database_default
and status <> @deleted

if @subtype is NULL
select @subtype=2
select @subtype

No comments:

Post a Comment

Total Pageviews