add_transactional_publication_on_database.sql

       use [<SourceDatabaseName>] 

       exec sp_addpublication @publication = N'<SourceDatabaseName>_PUB', @description = N'Transactional publication of database ''<SourceDatabaseName>'' from Publisher ''<SqlServerInstance_Publisher>''.', @sync_method = N'concurrent', @retention = 0, @allow_push = N'true', @allow_pull = N'true', @allow_anonymous = N'true', @enabled_for_internet = N'false', @snapshot_in_defaultfolder = N'true', @compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous', @allow_subscription_copy = N'false', @add_to_active_directory = N'false', @repl_freq = N'continuous', @status = N'active', @independent_agent = N'true', @immediate_sync = N'true', @allow_sync_tran = N'false', @autogen_sync_procs = N'false', @allow_queued_tran = N'false', @allow_dts = N'false', @replicate_ddl = 1, @allow_initialize_from_backup = N'false', @enabled_for_p2p = N'false', @enabled_for_het_sub = N'false' 

       GO 

       exec sp_addpublication_snapshot @publication = N'<SourceDatabaseName>_PUB', @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 = N'<db_Owner_USerName>', @job_password = '<UserPassword>', @publisher_security_mode = 1 

       exec sp_grant_publication_access @publication = N' <SourceDatabaseName> _PUB', @login = N'<SqlServerUser>'