-
Notifications
You must be signed in to change notification settings - Fork 0
/
NewSubscription.sql
7 lines (6 loc) · 2.24 KB
/
NewSubscription.sql
1
2
3
4
5
6
7
-----------------BEGIN: Script to be run at Publisher 'LAPTOP-FC24HOJJ\KHIET'-----------------
use [CarRental]
exec sp_addmergesubscription @publication = N'CarRental4', @subscriber = N'LAPTOP-FC24HOJJ\KHIET01', @subscriber_db = N'CarRental', @subscription_type = N'Push', @sync_type = N'Automatic', @subscriber_type = N'Global', @subscription_priority = 75, @description = null, @use_interactive_resolver = N'False'
exec sp_addmergepushsubscription_agent @publication = N'CarRental4', @subscriber = N'LAPTOP-FC24HOJJ\KHIET01', @subscriber_db = N'CarRental', @job_login = null, @job_password = null, @subscriber_security_mode = 0, @subscriber_login = N'sa', @subscriber_password = null, @publisher_security_mode = 1, @frequency_type = 64, @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 = 20231113, @active_end_date = 99991231, @enabled_for_syncmgr = N'False'
GO
-----------------END: Script to be run at Publisher 'LAPTOP-FC24HOJJ\KHIET'-----------------