May 25, 2012

sp_MSrepl_check_publisher (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_MSrepl_check_publisher(nvarchar @publisher_type
, nvarchar @publisher
, bit @security_mode
, nvarchar @login
, nvarchar @password
, int @connect_timeout)

MetaData:

   
--
-- Name:
-- sp_MSrepl_check_publisher
--
-- Description:
-- Determine if an ad-hoc datasource is currently published.
--
-- Returns:
-- Result set:
-- Distributor that owns publisher
-- NULL if not published
--
-- Security:
-- public
--
-- Notes:
-- Used by the UI
-- Connect time out is measure in seconds (default of 60)
--

CREATE PROCEDURE sys.sp_MSrepl_check_publisher
(
@publisher_type sysname,
@publisher sysname,
@security_mode bit = 1,
@login nvarchar(255) = null,
@password nvarchar(255) = null,
@connect_timeout int = 60
)
AS
BEGIN
DECLARE @retcode int

IF UPPER(@publisher_type) IN ('ORACLE', 'ORACLE GATEWAY')
BEGIN
EXEC sys.sp_ORAcheckpublisher @publisher,
@security_mode,
@login,
@password,
@connect_timeout
END
ELSE
BEGIN
RAISERROR(21645, 16, -1, @publisher_type)
RETURN (1)
END
END

No comments:

Post a Comment

Total Pageviews