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_adddistpublisher(nvarchar @publisher, nvarchar @distribution_db
, int @security_mode
, nvarchar @login
, nvarchar @password
, nvarchar @working_directory
, nvarchar @trusted
, bit @encrypted_password
, bit @thirdparty_flag
, nvarchar @publisher_type)
MetaData:
create procedure sys.sp_adddistpublisher
(
@publisher sysname,
@distribution_db sysname,
@security_mode int = 1,
@login sysname = NULL,
@password sysname = NULL,
@working_directory nvarchar(255) = NULL,
@trusted nvarchar(5) = 'false',
@encrypted_password bit = 0,
@thirdparty_flag bit = 0,
@publisher_type sysname = N'MSSQLSERVER'
)
AS
BEGIN
DECLARE @cmd nvarchar(4000)
DECLARE @retcode int
SET @retcode = 0
SET @cmd = N''
-- DEPRECATED PARAMETER: @trusted
-- For security reasons, @trusted is no longer supported.
-- Implicitly, it must always be @trusted == false. If
-- anything other than false is supplied, an error is thrown.
IF LOWER(@trusted collate SQL_Latin1_General_CP1_CS_AS) NOT IN ('false')
BEGIN
RAISERROR(21698, 16, -1, '@trusted')
RETURN (1)
END
-- Check if HREPL
IF NOT @publisher_type = N'MSSQLSERVER'
BEGIN
SET @cmd = @cmd + QUOTENAME(@distribution_db) + N'.'
END
-- Add sp
SET @publisher = UPPER(@publisher) COLLATE DATABASE_DEFAULT
set @cmd = @cmd + N'sys.sp_MSrepl_adddistpublisher'
EXEC @retcode = @cmd
@publisher,
@distribution_db,
@security_mode,
@login,
@password,
@working_directory,
@trusted,
@encrypted_password,
@thirdparty_flag,
@publisher_type
RETURN (@retcode)
END
No comments:
Post a Comment