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