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_setOraclepackageversion(nvarchar @publisher)MetaData:
CREATE PROCEDURE sys.sp_setOraclepackageversion
(
@publisher sysname
)
AS
BEGIN
set nocount on
DECLARE @cmd nvarchar(4000)
,@retcode int
,@publisher_type sysname
EXEC @retcode = sys.sp_MSrepl_getpublisherinfo
@publisher = @publisher,
@rpcheader = @cmd OUTPUT,
@publisher_type = @publisher_type OUTPUT
IF @retcode <> 0
RETURN (@retcode)
-- Reject unsupported publisher types
IF @publisher_type NOT IN (N'ORACLE', N'ORACLE GATEWAY')
BEGIN
RAISERROR (21645, 16, -1, @publisher_type)
RETURN (1)
END
SELECT @publisher = UPPER(@publisher)
,@cmd = @cmd + N'sys.sp_MSrepl_setOraclepackageversion'
EXEC @retcode = @cmd
@publisher
RETURN (@retcode)
END
No comments:
Post a Comment