May 8, 2012

sp_MScheck_merge_subscription_count (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_MScheck_merge_subscription_count(nvarchar @publisher
, int @publisher_engine_edition
, bit @about_to_insert_new_subscription)

MetaData:

 create proc sys.sp_MScheck_merge_subscription_count   
(
@publisher sysname,
@publisher_engine_edition int,
@about_to_insert_new_subscription bit
)
as
begin
set nocount on
declare @retcode int

-- Security Check: require sysadmin/dbo of dist
IF IS_MEMBER('db_owner') != 1
BEGIN
RAISERROR(21089,16,-1)
RETURN 1
END

-- database must be distribution db
IF sys.fn_MSrepl_isdistdb(DB_NAME()) <> 1
BEGIN
RAISERROR (21482, 16, -1, 'sp_MScheck_merge_subscription_count', 'distribution')
RETURN 1
END

exec @retcode = sys.sp_MScheck_subscription_count_internal @mode=1
,@publisher = @publisher
,@publisher_engine_edition = @publisher_engine_edition
,@about_to_insert_new_subscription = @about_to_insert_new_subscription
return @retcode
end

No comments:

Post a Comment

Total Pageviews