Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Replication in Non-Trusted Domains

Posted by Simon Cho on 08/14/2012

http://support.microsoft.com/kb/321822

exec sp_addpublication_snapshot
, @publisher_security_mode = 0
, @publisher_login = N’sql_Replication_user’
, @publisher_password = N’sql_Replication_user_password’


exec ReplicationDB.sys.sp_addlogreader_agent 
@job_login = null
, @job_password = null
, @publisher_security_mode = 0
, @publisher_login = N'sql_Replication_user'
, @publisher_password = N'sql_Replication_user_password'
GO

exec sp_addpublication_snapshot @publication = N'TestPublication'
, @frequency_type = 1
, @frequency_interval = 0
, @frequency_relative_interval = 0
, @frequency_recurrence_factor = 0
, @frequency_subday = 0
, @frequency_subday_interval = 0
, @active_start_time_of_day = 0
, @active_end_time_of_day = 235959
, @active_start_date = 0
, @active_end_date = 0
, @job_login = null
, @job_password = null
, @publisher_security_mode = 0
, @publisher_login = N'sql_Replication_user'
, @publisher_password = N'sql_Replication_user_password'
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: