/****** Scripting the replication setup of server WWW.XXXXXXX.NET. Script
Date: 2004-6-4 15:07:22 ******/
/****** Please note: Any password parameter was scripted with NULL or empty
string for security reason. ******/
/****** Begin: Script to be run at Distributor: WWW.XXXXXXX.NET ******/
/****** Installing the server YYYYYYY as a Distributor. Script Date:
2004-6-4 15:07:22 ******/
use master
GO
exec sp_adddistributor @distributor = N'YYYYYYY', @password = N''
GO
sp_MSupdate_agenttype_default @profile_id = 1
GO
sp_MSupdate_agenttype_default @profile_id = 2
GO
sp_MSupdate_agenttype_default @profile_id = 4
GO
sp_MSupdate_agenttype_default @profile_id = 6
GO
sp_MSupdate_agenttype_default @profile_id = 11
GO
exec sp_adddistributiondb @database = N'fenfa', @data_folder =
N'e:\sql.rpl', @data_file = N'fenfa.MDF', @data_file_size = 11, @log_folder
= N'h:\sql.rpl', @log_file = N'fenfa.LDF', @log_file_size = 1,
@min_distretention = 0, @max_distretention = 72, @history_retention = 48,
@security_mode = 0, @login = N'sa', @password = null
GO
exec sp_adddistpublisher @publisher = N'YYYYYYY', @distribution_db =
N'fenfa', @security_mode = 0, @login = N'sa', @password = N'',
@working_directory = N'\\YYYYYYY\dist', @trusted = N'false',
@thirdparty_flag = 0
GO
/****** End: Script to be run at Distributor: WWW.XXXXXXX.NET ******/
/****** Begin: Script to be run at Publisher: WWW.XXXXXXX.NET ******/
use master
GO
exec sp_replicationdboption @dbname = N'jinjian', @optname = N'publish',
@value = N'true'
GO
use [jinjian]
GO
exec sp_addpublication
@publication = N'jinjian',
@restricted = N'false',
@sync_method = N'native',
@repl_freq = N'continuous',
@description = N'',
@status = N'active',
@allow_push = N'true',
@allow_pull = N'true',
@allow_anonymous = N'true',
@enabled_for_internet = N'true',
@independent_agent = N'true',
@immediate_sync = N'true',
@allow_sync_tran = N'true',
@autogen_sync_procs = N'true',
@retention = 336,
@allow_queued_tran = N'false',
@snapshot_in_defaultfolder = N'false',
@alt_snapshot_folder = N'g:\websites\download.XXXXXXX.net\sqlserver',
@compress_snapshot = N'false',
@ftp_address = N'WWW.XXXXXXX.NET',
@ftp_port = 7504,
@ftp_login = N'sa',
@allow_dts = N'false',
@allow_subscription_copy = N'false',
@add_to_active_directory = N'false',
@logreader_job_name = N'YYYYYYY-jinjian-1'
exec sp_addpublication_snapshot
@publication = N'jinjian',
@frequency_type = 4,
@frequency_interval = 1,
@frequency_relative_interval = 1,
@frequency_recurrence_factor = 0,
@frequency_subday = 8,
@frequency_subday_interval = 1,
@active_start_date = 0,
@active_end_date = 0,
@active_start_time_of_day = 0,
@active_end_time_of_day = 235959,
@snapshot_job_name = N'YYYYYYY-jinjian-jinjian-1'
GO
exec sp_grant_publication_access
@publication = N'jinjian',
@login = N'BUILTIN\Administrators'
GO
exec sp_grant_publication_access
@publication = N'jinjian',
@login = N'distributor_admin'
GO
exec sp_grant_publication_access
@publication = N'jinjian',
@login = N'sa'
GO
exec sp_addarticle
@publication = N'jinjian',
@article = N'CompleteTotal',
@source_owner = N'dbo',
@source_object = N'CompleteTotal',
@destination_table = N'CompleteTotal',
@type = N'logbased',
@creation_script = null,
@description = null,
@pre_creation_cmd = N'drop',
@schema_option = 0x000000000000CEF3,
@status = 16,
@vertical_partition = N'false',
@ins_cmd = N'CALL sp_MSins_CompleteTotal',
@del_cmd = N'CALL sp_MSdel_CompleteTotal',
@upd_cmd = N'MCALL sp_MSupd_CompleteTotal',
@filter = null,
@sync_object = null,
@auto_identity_range = N'false'
GO
/****** End: Script to be run at Distributor: WWW.XXXXXXX.NET ******/
original