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