create procedure sys.sp_changesubscriber
(
	@subscriber						sysname,
	@type							tinyint = NULL,
	@login							sysname = NULL,
	@password						sysname = '%',
	@commit_batch_size				int = NULL,
	@status_batch_size				int = NULL,
	@flush_frequency				int = NULL,
	@frequency_type					int = NULL,
	@frequency_interval				int = NULL,
	@frequency_relative_interval	int = NULL,
	@frequency_recurrence_factor	int = NULL,
	@frequency_subday				int = NULL,
	@frequency_subday_interval		int = NULL,
	@active_start_time_of_day		int = NULL,
	@active_end_time_of_day			int = NULL,
	@active_start_date				int = NULL,
	@active_end_date				int = NULL,
	@description					nvarchar (255) = NULL,
	@security_mode					int = NULL,				/* 0 standard; 1 integrated */
	@publisher						sysname = NULL
)
AS
BEGIN
	DECLARE @cmd			nvarchar(4000)
	DECLARE @retcode		int
	DECLARE @publisher_type	sysname

	SET @retcode = 0
	
	EXEC @retcode = sys.sp_MSrepl_getpublisherinfo	@publisher		= @publisher,
													@rpcheader		= @cmd            OUTPUT,
													@publisher_type	= @publisher_type OUTPUT
	
	IF @retcode <> 0
		RETURN (@retcode)

	-- Add sp
	SET @publisher = UPPER(@publisher) COLLATE DATABASE_DEFAULT
	set @cmd = @cmd + N'sys.sp_MSrepl_changesubscriber'
	
	EXEC @retcode = @cmd
					@subscriber,
					@type,
					@login,
					@password,
					@commit_batch_size,
					@status_batch_size,
					@flush_frequency,
					@frequency_type,
					@frequency_interval,
					@frequency_relative_interval,
					@frequency_recurrence_factor,
					@frequency_subday,
					@frequency_subday_interval,
					@active_start_time_of_day,
					@active_end_time_of_day,
					@active_start_date,
					@active_end_date,
					@description,
					@security_mode,
					@publisher,
					@publisher_type

	RETURN (@retcode)
END