April 13, 2012

sp_adddistpublisher (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_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

Total Pageviews