Chris,

Apologies for misspelled your name!!!

Here is my database replication scripts:

use master

go

--- Create an entry on the sysserver tables, mark it as the Distributor

--- and stores property information.

--- heartbeat_interval in minutes

EXEC sp_adddistributor

@distributor = 'DistributorServerName',

@heartbeat_interval = 20, --- 20 minutes

@password = 'Password'

go

--- Create a new distribution database and install the Distribution schema

exec sp_adddistributiondb

@database = 'Tobe_Named_Distribution_Center',

@data_folder = 'D:\BnB_ReplData\sql_data',

@data_file = 'Tobe_Named_Distribution_Center.MDF',

@data_file_size = 100,

@log_folder = 'D:\BnB_ReplData\sql_log',

@log_file = 'Tobe_Named_Distribution_Center.LDF',

@log_file_size = 25,

@min_distretention = 24,

@max_distretention = 72,

@history_retention = 72,

@security_mode = 0,

@login = 'LoginID',

@password = 'Password'

GO

--- Configure a Publisher to use a specified distribution database

exec sp_adddistpublisher

@publisher = 'PublisherServerName',

@distribution_db = 'Tobe_Named_Distribution_Center',

@security_mode = 0,

@login = 'LoginID',

@password = 'Password',

@working_directory = N'\\MahcineName\D$\BnB_ReplData',

@trusted = 'true',

@thirdparty_flag = 0

GO

-- Add a subscriber server

EXEC sp_addsubscriber @subscriber = 'Subcriber Server Name'

,@type = 0

,@login = 'LoginID'

,@password = 'Password'

,@description = 'Subcriber Server Subscription'

,@security_mode = 0

GO

sp_addsubscriber_schedule @subscriber = 'Subcriber Server Name'

,@agent_type = 0

,@frequency_type = 4

,@frequency_interval = 1

,@frequency_relative_interval =1

,@frequency_recurrence_factor = 0

,@frequency_subday = 4

,@frequency_subday_interval = 10

,@active_start_time_of_day = 000700

,@active_end_time_of_day = 235959

,@active_start_date = 20071114

,@active_end_date = 99991231

GO

----- Need to switch the database

USE [SiteData]

GO

--- STEP 1 Configure the server/database for Snapshot replication

EXEC sp_replicationdboption @dbname = 'DabaseSiteData',

@optname = 'publish', @value = 'True'

GO

--- STEP 2 Creating and configuring the Snapshot Agen

--- Set a replication database option for the current database

-- Adding the transactional publication

exec sp_addpublication @publication = N'DatabaseSiteData',

@restricted = N'false',

@sync_method = N'native',

@repl_freq = N'continuous',

@description = N'Transactional publication of SiteData database from Publisher GHS0017RPT.',

@status = N'active',

@allow_push = N'true',

@allow_pull = N'true', @allow_anonymous = N'false',

@enabled_for_internet = N'false',

@independent_agent = N'false',

@immediate_sync = N'false',

@allow_sync_tran = N'false',

@autogen_sync_procs = N'false',

@retention = 336,

@allow_queued_tran = N'false',

@snapshot_in_defaultfolder = N'true',

@compress_snapshot = N'false',

@ftp_port = 21, @ftp_login = N'anonymous',

@allow_dts = N'false',

@allow_subscription_copy = N'false',

@add_to_active_directory = N'false',

@logreader_job_name = N'GHS0017RPT-SiteData-1'

GO

exec sp_addpublication_snapshot

@publication = N'DatabaseSiteData',

@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'BlaBlaBla'

GO

--- Adds a login to the publication's access list

exec sp_grant_publication_access

@publication = N'DabaseSiteData',

@login = N'LoginID'

GO

exec sp_grant_publication_access

@publication = N'DabaseSiteData',

@login = N'BUILTIN\Administrators'

GO

exec sp_grant_publication_access

@publication = N'DabaseSiteData',

@login = N'distributor_admin'

GO

---- Stop di sini

-- Adding the transactional articles

exec sp_addarticle @publication = N'DabaseSiteData',

@article = N't_EditTags',

@source_owner = N'dbo',

@source_object = N't_EditTags',

@destination_table = N't_EditTags',

@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_t_EditTags',

@del_cmd = N'CALL sp_MSdel_t_EditTags',

@upd_cmd = N'MCALL sp_MSupd_t_EditTags',

@filter = null, @sync_object = null,

@auto_identity_range = N'false'

GO