thierry/sql-scripts
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
sql-scripts/OCTPDBA-435 - SQL 2019 bug in Ceres Replication Maintenance tool/create apos subscription and articles.sql
Thierry Schork 7cf858256a initial commit
2022-12-30 12:10:12 +01:00

388 lines
69 KiB
Transact-SQL
Raw Permalink Blame History

-- Enabling the replication database
use master
exec sp_replicationdboption @dbname = N'ActivePos_read', @optname = N'publish', @value = N'true'
GO
exec [ActivePos_read].sys.sp_addlogreader_agent @job_login = N'CENTRALINFRA\svc-APH-repl', @job_password = 'TWdZItCqjU!uLgws', @publisher_security_mode = 1
GO
-- Adding the transactional publication
use [ActivePos_read]
exec sp_addpublication @publication = N'ActivePosTran', @description = N'Transactional publication of database ''ActivePos_Read''', @sync_method = N'concurrent', @retention = 120, @allow_push = N'true', @allow_pull = N'false', @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'true', @enabled_for_p2p = N'false', @enabled_for_het_sub = N'false'
GO
exec sp_addpublication_snapshot @publication = N'ActivePosTran', @frequency_type = 4, @frequency_interval = 1, @frequency_relative_interval = 1, @frequency_recurrence_factor = 0, @frequency_subday = 1, @frequency_subday_interval = 1, @active_start_time_of_day = 63000, @active_end_time_of_day = 235959, @active_start_date = 0, @active_end_date = 0, @job_login = N'CENTRALINFRA\svc-APH-repl', @job_password = 'TWdZItCqjU!uLgws', @publisher_security_mode = 1
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'sa'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'NT AUTHORITY\SYSTEM'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'AMAVITA\L-AM-AP-SQL-AMA-Pharmacy_Servers_Database_Administrator'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'AMAVITA\hcisqlrepl'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'AMAVITA\L-AM-AP-SQL-AMA-Pharmacy_Servers_Windows_Operations'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'CENTRALINFRA\svc-APH-repl'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'CENTRALINFRA\L-CI-AP-SQL-AMA-Pharmacy_Servers_Windows_Operations'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'CENTRALINFRA\L-CI-AP-SQL-AMA-Pharmacy_Servers_Database_Administrator'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'CENTRALINFRA\svc-GAIA-repl'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'CENTRALPHARMA\G-CP-RL-ORG-GX_IT_IS_WindowsEngineeringServicesI'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'NT SERVICE\SQLAgent$APSSQL'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'NT SERVICE\Winmgmt'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'NT SERVICE\SQLWriter'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'NT SERVICE\MSSQL$APSSQL'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'ittech'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'sqlAppAPHAdm'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'cslt'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'distributor_admin'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'dba'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'sup'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'sqlAppMonitoringviewerUsr'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'sqlLksrvTMPUsr'
GO
exec sp_grant_publication_access @publication = N'ActivePosTran', @login = N'dev'
GO
-- Adding the transactional articles
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'Brand', @source_owner = N'dbo', @source_object = N'Brand', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'Brand', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboBrand]', @del_cmd = N'CALL [sp_MSdel_dboBrand]', @upd_cmd = N'SCALL [sp_MSupd_dboBrand]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'BrevierText', @source_owner = N'dbo', @source_object = N'BrevierText', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'BrevierText', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboBrevierText]', @del_cmd = N'CALL [sp_MSdel_dboBrevierText]', @upd_cmd = N'SCALL [sp_MSupd_dboBrevierText]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ClinicalCheck', @source_owner = N'dbo', @source_object = N'ClinicalCheck', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ClinicalCheck', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboClinicalCheck]', @del_cmd = N'CALL [sp_MSdel_dboClinicalCheck]', @upd_cmd = N'SCALL [sp_MSupd_dboClinicalCheck]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ClinicalCheckToPatient', @source_owner = N'dbo', @source_object = N'ClinicalCheckToPatient', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ClinicalCheckToPatient', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboClinicalCheckToPatient]', @del_cmd = N'CALL [sp_MSdel_dboClinicalCheckToPatient]', @upd_cmd = N'SCALL [sp_MSupd_dboClinicalCheckToPatient]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ClinicalCheckType', @source_owner = N'dbo', @source_object = N'ClinicalCheckType', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ClinicalCheckType', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboClinicalCheckType]', @del_cmd = N'CALL [sp_MSdel_dboClinicalCheckType]', @upd_cmd = N'SCALL [sp_MSupd_dboClinicalCheckType]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'CommonVar', @source_owner = N'dbo', @source_object = N'CommonVar', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'CommonVar', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboCommonVar]', @del_cmd = N'CALL [sp_MSdel_dboCommonVar]', @upd_cmd = N'SCALL [sp_MSupd_dboCommonVar]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'Criteria', @source_owner = N'dbo', @source_object = N'Criteria', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'Criteria', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboCriteria]', @del_cmd = N'CALL [sp_MSdel_dboCriteria]', @upd_cmd = N'SCALL [sp_MSupd_dboCriteria]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'CustomerCard', @source_owner = N'dbo', @source_object = N'CustomerCard', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'CustomerCard', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboCustomerCard]', @del_cmd = N'CALL [sp_MSdel_dboCustomerCard]', @upd_cmd = N'SCALL [sp_MSupd_dboCustomerCard]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'CustomerReminder', @source_owner = N'dbo', @source_object = N'CustomerReminder', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'CustomerReminder', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboCustomerReminder]', @del_cmd = N'CALL [sp_MSdel_dboCustomerReminder]', @upd_cmd = N'SCALL [sp_MSupd_dboCustomerReminder]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'DatabaseHistory', @source_owner = N'upd', @source_object = N'DatabaseHistory', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'manual', @destination_table = N'DatabaseHistory', @destination_owner = N'upd', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_updDatabaseHistory]', @del_cmd = N'CALL [sp_MSdel_updDatabaseHistory]', @upd_cmd = N'SCALL [sp_MSupd_updDatabaseHistory]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'DiscountVoucher', @source_owner = N'dbo', @source_object = N'DiscountVoucher', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'DiscountVoucher', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboDiscountVoucher]', @del_cmd = N'CALL [sp_MSdel_dboDiscountVoucher]', @upd_cmd = N'SCALL [sp_MSupd_dboDiscountVoucher]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'DiscountVoucherActionDefinition', @source_owner = N'dbo', @source_object = N'DiscountVoucherActionDefinition', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'DiscountVoucherActionDefinition', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboDiscountVoucherActionDefinition]', @del_cmd = N'CALL [sp_MSdel_dboDiscountVoucherActionDefinition]', @upd_cmd = N'SCALL [sp_MSupd_dboDiscountVoucherActionDefinition]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'DiscountVoucherActionDefinitionSpecificTargetItem', @source_owner = N'dbo', @source_object = N'DiscountVoucherActionDefinitionSpecificTargetItem', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'DiscountVoucherActionDefinitionSpecificTargetItem', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboDiscountVoucherActionDefinitionSpecificTargetItem]', @del_cmd = N'CALL [sp_MSdel_dboDiscountVoucherActionDefinitionSpecificTargetItem]', @upd_cmd = N'SCALL [sp_MSupd_dboDiscountVoucherActionDefinitionSpecificTargetItem]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'DiscountVoucherCondition', @source_owner = N'dbo', @source_object = N'DiscountVoucherCondition', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'DiscountVoucherCondition', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboDiscountVoucherCondition]', @del_cmd = N'CALL [sp_MSdel_dboDiscountVoucherCondition]', @upd_cmd = N'SCALL [sp_MSupd_dboDiscountVoucherCondition]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'DiscountVoucherCouponActionDefinition', @source_owner = N'dbo', @source_object = N'DiscountVoucherCouponActionDefinition', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'DiscountVoucherCouponActionDefinition', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboDiscountVoucherCouponActionDefinition]', @del_cmd = N'CALL [sp_MSdel_dboDiscountVoucherCouponActionDefinition]', @upd_cmd = N'SCALL [sp_MSupd_dboDiscountVoucherCouponActionDefinition]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'DiscountVoucherCouponActionDefinitionPrinting', @source_owner = N'dbo', @source_object = N'DiscountVoucherCouponActionDefinitionPrinting', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'DiscountVoucherCouponActionDefinitionPrinting', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboDiscountVoucherCouponActionDefinitionPrinting]', @del_cmd = N'CALL [sp_MSdel_dboDiscountVoucherCouponActionDefinitionPrinting]', @upd_cmd = N'SCALL [sp_MSupd_dboDiscountVoucherCouponActionDefinitionPrinting]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'DiscountVoucherCouponActionDefinitionText', @source_owner = N'dbo', @source_object = N'DiscountVoucherCouponActionDefinitionText', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'DiscountVoucherCouponActionDefinitionText', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboDiscountVoucherCouponActionDefinitionText]', @del_cmd = N'CALL [sp_MSdel_dboDiscountVoucherCouponActionDefinitionText]', @upd_cmd = N'SCALL [sp_MSupd_dboDiscountVoucherCouponActionDefinitionText]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'DiscountVoucherPackageElement', @source_owner = N'dbo', @source_object = N'DiscountVoucherPackageElement', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'DiscountVoucherPackageElement', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboDiscountVoucherPackageElement]', @del_cmd = N'CALL [sp_MSdel_dboDiscountVoucherPackageElement]', @upd_cmd = N'SCALL [sp_MSupd_dboDiscountVoucherPackageElement]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'DiscountVoucherText', @source_owner = N'dbo', @source_object = N'DiscountVoucherText', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'DiscountVoucherText', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboDiscountVoucherText]', @del_cmd = N'CALL [sp_MSdel_dboDiscountVoucherText]', @upd_cmd = N'SCALL [sp_MSupd_dboDiscountVoucherText]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIBill_Pharmacists_Header', @source_owner = N'dbo', @source_object = N'IIIBill_Pharmacists_Header', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIBill_Pharmacists_Header', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIBill_Pharmacists_Header]', @del_cmd = N'CALL [sp_MSdel_dboIIIBill_Pharmacists_Header]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIBill_Pharmacists_Header]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIICommon_Bank_PTT_Master', @source_owner = N'dbo', @source_object = N'IIICommon_Bank_PTT_Master', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIICommon_Bank_PTT_Master', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIICommon_Bank_PTT_Master]', @del_cmd = N'CALL [sp_MSdel_dboIIICommon_Bank_PTT_Master]', @upd_cmd = N'SCALL [sp_MSupd_dboIIICommon_Bank_PTT_Master]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIICommunicationItem', @source_owner = N'dbo', @source_object = N'IIICommunicationItem', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIICommunicationItem', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIICommunicationItem]', @del_cmd = N'CALL [sp_MSdel_dboIIICommunicationItem]', @upd_cmd = N'SCALL [sp_MSupd_dboIIICommunicationItem]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIICountry_Master', @source_owner = N'dbo', @source_object = N'IIICountry_Master', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIICountry_Master', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIICountry_Master]', @del_cmd = N'CALL [sp_MSdel_dboIIICountry_Master]', @upd_cmd = N'SCALL [sp_MSupd_dboIIICountry_Master]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIICoverage_Documents', @source_owner = N'dbo', @source_object = N'IIICoverage_Documents', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIICoverage_Documents', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIICoverage_Documents]', @del_cmd = N'CALL [sp_MSdel_dboIIICoverage_Documents]', @upd_cmd = N'SCALL [sp_MSupd_dboIIICoverage_Documents]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIICurrency_Master', @source_owner = N'dbo', @source_object = N'IIICurrency_Master', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIICurrency_Master', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIICurrency_Master]', @del_cmd = N'CALL [sp_MSdel_dboIIICurrency_Master]', @upd_cmd = N'SCALL [sp_MSupd_dboIIICurrency_Master]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIICustomer', @source_owner = N'dbo', @source_object = N'IIICustomer', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIICustomer', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIICustomer]', @del_cmd = N'CALL [sp_MSdel_dboIIICustomer]', @upd_cmd = N'SCALL [sp_MSupd_dboIIICustomer]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIICustomerCategory', @source_owner = N'dbo', @source_object = N'IIICustomerCategory', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIICustomerCategory', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIICustomerCategory]', @del_cmd = N'CALL [sp_MSdel_dboIIICustomerCategory]', @upd_cmd = N'SCALL [sp_MSupd_dboIIICustomerCategory]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIICustomerGroup', @source_owner = N'dbo', @source_object = N'IIICustomerGroup', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIICustomerGroup', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIICustomerGroup]', @del_cmd = N'CALL [sp_MSdel_dboIIICustomerGroup]', @upd_cmd = N'SCALL [sp_MSupd_dboIIICustomerGroup]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIICustomerToPerson', @source_owner = N'dbo', @source_object = N'IIICustomerToPerson', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'manual', @destination_table = N'IIICustomerToPerson', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIICustomerToPerson]', @del_cmd = N'CALL [sp_MSdel_dboIIICustomerToPerson]', @upd_cmd = N'SCALL [sp_MSupd_dboIIICustomerToPerson]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIDelivery_Note_Header', @source_owner = N'dbo', @source_object = N'IIIDelivery_Note_Header', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIDelivery_Note_Header', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIDelivery_Note_Header]', @del_cmd = N'CALL [sp_MSdel_dboIIIDelivery_Note_Header]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIDelivery_Note_Header]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIDiscountOperation', @source_owner = N'dbo', @source_object = N'IIIDiscountOperation', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIDiscountOperation', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIDiscountOperation]', @del_cmd = N'CALL [sp_MSdel_dboIIIDiscountOperation]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIDiscountOperation]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIDiscountSchemaDetail', @source_owner = N'dbo', @source_object = N'IIIDiscountSchemaDetail', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIDiscountSchemaDetail', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIDiscountSchemaDetail]', @del_cmd = N'CALL [sp_MSdel_dboIIIDiscountSchemaDetail]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIDiscountSchemaDetail]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIExchange_rate', @source_owner = N'dbo', @source_object = N'IIIExchange_rate', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIExchange_rate', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIExchange_rate]', @del_cmd = N'CALL [sp_MSdel_dboIIIExchange_rate]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIExchange_rate]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIGaldatCode11', @source_owner = N'dbo', @source_object = N'IIIGaldatCode11', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIGaldatCode11', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIGaldatCode11]', @del_cmd = N'CALL [sp_MSdel_dboIIIGaldatCode11]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIGaldatCode11]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIInsurance_Master', @source_owner = N'dbo', @source_object = N'IIIInsurance_Master', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIInsurance_Master', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIInsurance_Master]', @del_cmd = N'CALL [sp_MSdel_dboIIIInsurance_Master]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIInsurance_Master]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIInsuranceAgreement', @source_owner = N'dbo', @source_object = N'IIIInsuranceAgreement', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIInsuranceAgreement', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIInsuranceAgreement]', @del_cmd = N'CALL [sp_MSdel_dboIIIInsuranceAgreement]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIInsuranceAgreement]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIInsuranceCodeException', @source_owner = N'dbo', @source_object = N'IIIInsuranceCodeException', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIInsuranceCodeException', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIInsuranceCodeException]', @del_cmd = N'CALL [sp_MSdel_dboIIIInsuranceCodeException]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIInsuranceCodeException]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIInsuranceGroup', @source_owner = N'dbo', @source_object = N'IIIInsuranceGroup', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIInsuranceGroup', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIInsuranceGroup]', @del_cmd = N'CALL [sp_MSdel_dboIIIInsuranceGroup]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIInsuranceGroup]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIInsuranceGroupLink', @source_owner = N'dbo', @source_object = N'IIIInsuranceGroupLink', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIInsuranceGroupLink', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIInsuranceGroupLink]', @del_cmd = N'CALL [sp_MSdel_dboIIIInsuranceGroupLink]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIInsuranceGroupLink]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIInsuranceTaxLink', @source_owner = N'dbo', @source_object = N'IIIInsuranceTaxLink', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIInsuranceTaxLink', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIInsuranceTaxLink]', @del_cmd = N'CALL [sp_MSdel_dboIIIInsuranceTaxLink]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIInsuranceTaxLink]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIItemCommercialRule', @source_owner = N'dbo', @source_object = N'IIIItemCommercialRule', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIItemCommercialRule', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIItemCommercialRule]', @del_cmd = N'CALL [sp_MSdel_dboIIIItemCommercialRule]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIItemCommercialRule]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIItemLink', @source_owner = N'dbo', @source_object = N'IIIItemLink', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIItemLink', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIItemLink]', @del_cmd = N'CALL [sp_MSdel_dboIIIItemLink]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIItemLink]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIItemRelation', @source_owner = N'dbo', @source_object = N'IIIItemRelation', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIItemRelation', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIItemRelation]', @del_cmd = N'CALL [sp_MSdel_dboIIIItemRelation]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIItemRelation]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIManufacturer', @source_owner = N'dbo', @source_object = N'IIIManufacturer', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIManufacturer', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIManufacturer]', @del_cmd = N'CALL [sp_MSdel_dboIIIManufacturer]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIManufacturer]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIINetwork_Registration_Detail', @source_owner = N'dbo', @source_object = N'IIINetwork_Registration_Detail', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIINetwork_Registration_Detail', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIINetwork_Registration_Detail]', @del_cmd = N'CALL [sp_MSdel_dboIIINetwork_Registration_Detail]', @upd_cmd = N'SCALL [sp_MSupd_dboIIINetwork_Registration_Detail]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIINetworkDiscount', @source_owner = N'dbo', @source_object = N'IIINetworkDiscount', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIINetworkDiscount', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIINetworkDiscount]', @del_cmd = N'CALL [sp_MSdel_dboIIINetworkDiscount]', @upd_cmd = N'SCALL [sp_MSupd_dboIIINetworkDiscount]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPartner_Item_Details', @source_owner = N'dbo', @source_object = N'IIIPartner_Item_Details', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPartner_Item_Details', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPartner_Item_Details]', @del_cmd = N'CALL [sp_MSdel_dboIIIPartner_Item_Details]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPartner_Item_Details]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPartner_Stock_Details', @source_owner = N'dbo', @source_object = N'IIIPartner_Stock_Details', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPartner_Stock_Details', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPartner_Stock_Details]', @del_cmd = N'CALL [sp_MSdel_dboIIIPartner_Stock_Details]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPartner_Stock_Details]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPatient_Insurance', @source_owner = N'dbo', @source_object = N'IIIPatient_Insurance', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPatient_Insurance', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPatient_Insurance]', @del_cmd = N'CALL [sp_MSdel_dboIIIPatient_Insurance]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPatient_Insurance]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPayment', @source_owner = N'dbo', @source_object = N'IIIPayment', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'manual', @destination_table = N'IIIPayment', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPayment]', @del_cmd = N'CALL [sp_MSdel_dboIIIPayment]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPayment]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPerson', @source_owner = N'dbo', @source_object = N'IIIPerson', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPerson', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPerson]', @del_cmd = N'CALL [sp_MSdel_dboIIIPerson]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPerson]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPerson_Title', @source_owner = N'dbo', @source_object = N'IIIPerson_Title', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPerson_Title', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPerson_Title]', @del_cmd = N'CALL [sp_MSdel_dboIIIPerson_Title]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPerson_Title]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPharmaceutical_Master', @source_owner = N'dbo', @source_object = N'IIIPharmaceutical_Master', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPharmaceutical_Master', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPharmaceutical_Master]', @del_cmd = N'CALL [sp_MSdel_dboIIIPharmaceutical_Master]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPharmaceutical_Master]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPharmacy', @source_owner = N'dbo', @source_object = N'IIIPharmacy', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPharmacy', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPharmacy]', @del_cmd = N'CALL [sp_MSdel_dboIIIPharmacy]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPharmacy]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPhysician', @source_owner = N'dbo', @source_object = N'IIIPhysician', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPhysician', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPhysician]', @del_cmd = N'CALL [sp_MSdel_dboIIIPhysician]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPhysician]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPrescription_hdr', @source_owner = N'dbo', @source_object = N'IIIPrescription_hdr', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPrescription_hdr', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPrescription_hdr]', @del_cmd = N'CALL [sp_MSdel_dboIIIPrescription_hdr]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPrescription_hdr]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPrice', @source_owner = N'dbo', @source_object = N'IIIPrice', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPrice', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPrice]', @del_cmd = N'CALL [sp_MSdel_dboIIIPrice]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPrice]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPriceCode', @source_owner = N'dbo', @source_object = N'IIIPriceCode', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPriceCode', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPriceCode]', @del_cmd = N'CALL [sp_MSdel_dboIIIPriceCode]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPriceCode]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIPriceModifier', @source_owner = N'dbo', @source_object = N'IIIPriceModifier', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIPriceModifier', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIPriceModifier]', @del_cmd = N'CALL [sp_MSdel_dboIIIPriceModifier]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIPriceModifier]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIProduct_Form', @source_owner = N'dbo', @source_object = N'IIIProduct_Form', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIProduct_Form', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIProduct_Form]', @del_cmd = N'CALL [sp_MSdel_dboIIIProduct_Form]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIProduct_Form]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIRayon_Code_Master', @source_owner = N'dbo', @source_object = N'IIIRayon_Code_Master', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIRayon_Code_Master', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIRayon_Code_Master]', @del_cmd = N'CALL [sp_MSdel_dboIIIRayon_Code_Master]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIRayon_Code_Master]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIRefundException', @source_owner = N'dbo', @source_object = N'IIIRefundException', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIRefundException', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIRefundException]', @del_cmd = N'CALL [sp_MSdel_dboIIIRefundException]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIRefundException]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIRepetition_Info', @source_owner = N'dbo', @source_object = N'IIIRepetition_Info', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIRepetition_Info', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIRepetition_Info]', @del_cmd = N'CALL [sp_MSdel_dboIIIRepetition_Info]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIRepetition_Info]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIISales_Order_Detail', @source_owner = N'dbo', @source_object = N'IIISales_Order_Detail', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIISales_Order_Detail', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIISales_Order_Detail]', @del_cmd = N'CALL [sp_MSdel_dboIIISales_Order_Detail]', @upd_cmd = N'SCALL [sp_MSupd_dboIIISales_Order_Detail]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIISales_Order_Detail_Additional_Info', @source_owner = N'dbo', @source_object = N'IIISales_Order_Detail_Additional_Info', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIISales_Order_Detail_Additional_Info', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIISales_Order_Detail_Additional_Info]', @del_cmd = N'CALL [sp_MSdel_dboIIISales_Order_Detail_Additional_Info]', @upd_cmd = N'SCALL [sp_MSupd_dboIIISales_Order_Detail_Additional_Info]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIISales_Order_Header', @source_owner = N'dbo', @source_object = N'IIISales_Order_Header', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIISales_Order_Header', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIISales_Order_Header]', @del_cmd = N'CALL [sp_MSdel_dboIIISales_Order_Header]', @upd_cmd = N'SCALL [sp_MSupd_dboIIISales_Order_Header]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIService_Master', @source_owner = N'dbo', @source_object = N'IIIService_Master', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIService_Master', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIService_Master]', @del_cmd = N'CALL [sp_MSdel_dboIIIService_Master]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIService_Master]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIISmall_Expense_Master', @source_owner = N'dbo', @source_object = N'IIISmall_Expense_Master', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIISmall_Expense_Master', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIISmall_Expense_Master]', @del_cmd = N'CALL [sp_MSdel_dboIIISmall_Expense_Master]', @upd_cmd = N'SCALL [sp_MSupd_dboIIISmall_Expense_Master]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIISpecialDiscountSchema', @source_owner = N'dbo', @source_object = N'IIISpecialDiscountSchema', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIISpecialDiscountSchema', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIISpecialDiscountSchema]', @del_cmd = N'CALL [sp_MSdel_dboIIISpecialDiscountSchema]', @upd_cmd = N'SCALL [sp_MSupd_dboIIISpecialDiscountSchema]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIISpecialDiscountSchemaDetail', @source_owner = N'dbo', @source_object = N'IIISpecialDiscountSchemaDetail', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIISpecialDiscountSchemaDetail', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIISpecialDiscountSchemaDetail]', @del_cmd = N'CALL [sp_MSdel_dboIIISpecialDiscountSchemaDetail]', @upd_cmd = N'SCALL [sp_MSupd_dboIIISpecialDiscountSchemaDetail]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIISpecialDiscountSchemaDetail_old_prod_2', @source_owner = N'dbo', @source_object = N'IIISpecialDiscountSchemaDetail_old_prod_2', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIISpecialDiscountSchemaDetail_old_prod_2', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIISpecialDiscountSchemaDetail_old_prod_2]', @del_cmd = N'CALL [sp_MSdel_dboIIISpecialDiscountSchemaDetail_old_prod_2]', @upd_cmd = N'SCALL [sp_MSupd_dboIIISpecialDiscountSchemaDetail_old_prod_2]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIStorage_Area', @source_owner = N'dbo', @source_object = N'IIIStorage_Area', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIStorage_Area', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIStorage_Area]', @del_cmd = N'CALL [sp_MSdel_dboIIIStorage_Area]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIStorage_Area]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIITax', @source_owner = N'dbo', @source_object = N'IIITax', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIITax', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIITax]', @del_cmd = N'CALL [sp_MSdel_dboIIITax]', @upd_cmd = N'SCALL [sp_MSupd_dboIIITax]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIUserDetails', @source_owner = N'dbo', @source_object = N'IIIUserDetails', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIUserDetails', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIUserDetails]', @del_cmd = N'CALL [sp_MSdel_dboIIIUserDetails]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIUserDetails]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIVat_Code_Master', @source_owner = N'dbo', @source_object = N'IIIVat_Code_Master', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIVat_Code_Master', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIVat_Code_Master]', @del_cmd = N'CALL [sp_MSdel_dboIIIVat_Code_Master]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIVat_Code_Master]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'IIIZip_master', @source_owner = N'dbo', @source_object = N'IIIZip_master', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'IIIZip_master', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboIIIZip_master]', @del_cmd = N'CALL [sp_MSdel_dboIIIZip_master]', @upd_cmd = N'SCALL [sp_MSupd_dboIIIZip_master]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'InsuranceNetwork', @source_owner = N'dbo', @source_object = N'InsuranceNetwork', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'InsuranceNetwork', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboInsuranceNetwork]', @del_cmd = N'CALL [sp_MSdel_dboInsuranceNetwork]', @upd_cmd = N'SCALL [sp_MSupd_dboInsuranceNetwork]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'Interaction', @source_owner = N'dbo', @source_object = N'Interaction', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'Interaction', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboInteraction]', @del_cmd = N'CALL [sp_MSdel_dboInteraction]', @upd_cmd = N'SCALL [sp_MSupd_dboInteraction]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ItemComposition', @source_owner = N'dbo', @source_object = N'ItemComposition', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ItemComposition', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboItemComposition]', @del_cmd = N'CALL [sp_MSdel_dboItemComposition]', @upd_cmd = N'SCALL [sp_MSupd_dboItemComposition]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ItemInteraction', @source_owner = N'dbo', @source_object = N'ItemInteraction', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ItemInteraction', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboItemInteraction]', @del_cmd = N'CALL [sp_MSdel_dboItemInteraction]', @upd_cmd = N'SCALL [sp_MSupd_dboItemInteraction]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ItemLimitation', @source_owner = N'dbo', @source_object = N'ItemLimitation', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ItemLimitation', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboItemLimitation]', @del_cmd = N'CALL [sp_MSdel_dboItemLimitation]', @upd_cmd = N'SCALL [sp_MSupd_dboItemLimitation]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ItemLocation', @source_owner = N'dbo', @source_object = N'ItemLocation', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ItemLocation', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboItemLocation]', @del_cmd = N'CALL [sp_MSdel_dboItemLocation]', @upd_cmd = N'SCALL [sp_MSupd_dboItemLocation]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ItemRegulationInfo', @source_owner = N'dbo', @source_object = N'ItemRegulationInfo', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ItemRegulationInfo', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboItemRegulationInfo]', @del_cmd = N'CALL [sp_MSdel_dboItemRegulationInfo]', @upd_cmd = N'SCALL [sp_MSupd_dboItemRegulationInfo]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ItemSearch', @source_owner = N'dbo', @source_object = N'ItemSearch', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ItemSearch', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboItemSearch]', @del_cmd = N'CALL [sp_MSdel_dboItemSearch]', @upd_cmd = N'SCALL [sp_MSupd_dboItemSearch]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ItemSite', @source_owner = N'dbo', @source_object = N'ItemSite', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ItemSite', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboItemSite]', @del_cmd = N'CALL [sp_MSdel_dboItemSite]', @upd_cmd = N'SCALL [sp_MSupd_dboItemSite]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'ItemText', @source_owner = N'dbo', @source_object = N'ItemText', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'ItemText', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboItemText]', @del_cmd = N'CALL [sp_MSdel_dboItemText]', @upd_cmd = N'SCALL [sp_MSupd_dboItemText]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'MigrationScriptHistory', @source_owner = N'upd', @source_object = N'MigrationScriptHistory', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'manual', @destination_table = N'MigrationScriptHistory', @destination_owner = N'upd', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_updMigrationScriptHistory]', @del_cmd = N'CALL [sp_MSdel_updMigrationScriptHistory]', @upd_cmd = N'SCALL [sp_MSupd_updMigrationScriptHistory]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'NumeraryValue', @source_owner = N'dbo', @source_object = N'NumeraryValue', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'NumeraryValue', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboNumeraryValue]', @del_cmd = N'CALL [sp_MSdel_dboNumeraryValue]', @upd_cmd = N'SCALL [sp_MSupd_dboNumeraryValue]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'Operation', @source_owner = N'dbo', @source_object = N'Operation', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'Operation', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboOperation]', @del_cmd = N'CALL [sp_MSdel_dboOperation]', @upd_cmd = N'SCALL [sp_MSupd_dboOperation]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'OperationRole', @source_owner = N'dbo', @source_object = N'OperationRole', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'OperationRole', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboOperationRole]', @del_cmd = N'CALL [sp_MSdel_dboOperationRole]', @upd_cmd = N'SCALL [sp_MSupd_dboOperationRole]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'OuManager', @source_owner = N'dbo', @source_object = N'OuManager', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'OuManager', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboOuManager]', @del_cmd = N'CALL [sp_MSdel_dboOuManager]', @upd_cmd = N'SCALL [sp_MSupd_dboOuManager]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'PatientQuickInfo', @source_owner = N'dbo', @source_object = N'PatientQuickInfo', @type = N'view schema only', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x0000000008000001, @destination_table = N'PatientQuickInfo', @destination_owner = N'dbo', @status = 16
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'PharmacyItemLink', @source_owner = N'dbo', @source_object = N'PharmacyItemLink', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'PharmacyItemLink', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboPharmacyItemLink]', @del_cmd = N'CALL [sp_MSdel_dboPharmacyItemLink]', @upd_cmd = N'SCALL [sp_MSupd_dboPharmacyItemLink]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'PointOfSale', @source_owner = N'dbo', @source_object = N'PointOfSale', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'PointOfSale', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboPointOfSale]', @del_cmd = N'CALL [sp_MSdel_dboPointOfSale]', @upd_cmd = N'SCALL [sp_MSupd_dboPointOfSale]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'Posology', @source_owner = N'dbo', @source_object = N'Posology', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'Posology', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboPosology]', @del_cmd = N'CALL [sp_MSdel_dboPosology]', @upd_cmd = N'SCALL [sp_MSupd_dboPosology]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'PrescriberRole', @source_owner = N'dbo', @source_object = N'PrescriberRole', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'PrescriberRole', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboPrescriberRole]', @del_cmd = N'CALL [sp_MSdel_dboPrescriberRole]', @upd_cmd = N'SCALL [sp_MSupd_dboPrescriberRole]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'QrCodes', @source_owner = N'dbo', @source_object = N'QrCodes', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'QrCodes', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboQrCodes]', @del_cmd = N'CALL [sp_MSdel_dboQrCodes]', @upd_cmd = N'SCALL [sp_MSupd_dboQrCodes]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'Report', @source_owner = N'dbo', @source_object = N'Report', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'Report', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboReport]', @del_cmd = N'CALL [sp_MSdel_dboReport]', @upd_cmd = N'SCALL [sp_MSupd_dboReport]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'Role', @source_owner = N'dbo', @source_object = N'Role', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'Role', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboRole]', @del_cmd = N'CALL [sp_MSdel_dboRole]', @upd_cmd = N'SCALL [sp_MSupd_dboRole]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'RunOnceScriptHistory', @source_owner = N'upd', @source_object = N'RunOnceScriptHistory', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'manual', @destination_table = N'RunOnceScriptHistory', @destination_owner = N'upd', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_updRunOnceScriptHistory]', @del_cmd = N'CALL [sp_MSdel_updRunOnceScriptHistory]', @upd_cmd = N'SCALL [sp_MSupd_updRunOnceScriptHistory]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'StandardText', @source_owner = N'dbo', @source_object = N'StandardText', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'StandardText', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboStandardText]', @del_cmd = N'CALL [sp_MSdel_dboStandardText]', @upd_cmd = N'SCALL [sp_MSupd_dboStandardText]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'StandardTextText', @source_owner = N'dbo', @source_object = N'StandardTextText', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'manual', @destination_table = N'StandardTextText', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboStandardTextText]', @del_cmd = N'CALL [sp_MSdel_dboStandardTextText]', @upd_cmd = N'SCALL [sp_MSupd_dboStandardTextText]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'Substance', @source_owner = N'dbo', @source_object = N'Substance', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'Substance', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboSubstance]', @del_cmd = N'CALL [sp_MSdel_dboSubstance]', @upd_cmd = N'SCALL [sp_MSupd_dboSubstance]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'UserRole', @source_owner = N'dbo', @source_object = N'UserRole', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'UserRole', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboUserRole]', @del_cmd = N'CALL [sp_MSdel_dboUserRole]', @upd_cmd = N'SCALL [sp_MSupd_dboUserRole]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'VestaVersion', @source_owner = N'vesta', @source_object = N'VestaVersion', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'manual', @destination_table = N'VestaVersion', @destination_owner = N'vesta', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_vestaVestaVersion]', @del_cmd = N'CALL [sp_MSdel_vestaVestaVersion]', @upd_cmd = N'SCALL [sp_MSupd_vestaVestaVersion]'
GO
use [ActivePos_read]
exec sp_addarticle @publication = N'ActivePosTran', @article = N'WebService', @source_owner = N'dbo', @source_object = N'WebService', @type = N'logbased', @description = N'', @creation_script = N'', @pre_creation_cmd = N'drop', @schema_option = 0x00000000080351FF, @identityrangemanagementoption = N'none', @destination_table = N'WebService', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [sp_MSins_dboWebService]', @del_cmd = N'CALL [sp_MSdel_dboWebService]', @upd_cmd = N'SCALL [sp_MSupd_dboWebService]'
GO
-- Adding the transactional subscriptions
use [ActivePos_read]
exec sp_addsubscription @publication = N'ActivePosTran', @subscriber = N'WAM707A02', @destination_db = N'ActivePos_read', @subscription_type = N'Push', @sync_type = N'replication support only', @article = N'all', @update_mode = N'read only', @subscriber_type = 0
exec sp_addpushsubscription_agent @publication = N'ActivePosTran', @subscriber = N'WAM707A02', @subscriber_db = N'ActivePos_read', @job_login = null, @job_password = null, @subscriber_security_mode = 0, @subscriber_login = N'sqlAppAPHPosUsr', @subscriber_password = 'albKEDO!x$s4HbE%%IXq', @frequency_type = 64, @frequency_interval = 1, @frequency_relative_interval = 1, @frequency_recurrence_factor = 0, @frequency_subday = 4, @frequency_subday_interval = 5, @active_start_time_of_day = 0, @active_end_time_of_day = 235959, @active_start_date = 0, @active_end_date = 0, @dts_package_location = N'Distributor'
GO
Reference in New Issue View Git Blame Copy Permalink