Реферат Автоматизована система для роботи поліклініки

еплікаціі_replicationdboption

@ dbname = N'kp_bd ',

@ optname = N'publish ',

@ value = N'true '

-Додамо агента читання журналу в базу даних. [kp_bd]. sys.sp_addlogreader_agent

@ job_login = null,

@ job_password = null,

@ publisher_security_mode = 1

-Додамо агента читання черзі для зазначеного розповсюджувача: [kp_bd]. sys.sp_addqreader_agent

@ job_login = null,

@ job_password = null, @ frompublisher = 1

- Додавання публікації транзакцій [kp_bd] _addpublication

@ publication = N'pub1 ',

@ description = N'Публікаціятранзакцій з оновлюваними підписками бази даних "kp_bd" від видавця "REDWHITE-ПК MSSQLSERVERSERJ1". ',

@ 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'true ', @ autogen_sync_procs = N'true',

@ allow_queued_tran = N'true ',

@ allow_dts = N'false ',

@ conflict_policy = N'pub wins ',

@ centralized_conflicts = N'true ', @ conflict_retention = 14,

@ queue_type = N'sql ',

@ replicate_ddl = 1, @ allow_initialize_from_backup = N'false ',

@ enabled_for_p2p = N'false ', @ enabled_for_het_sub = N'false'

-создат агента моментальних знімків для публікаціі._addpublication_snapshot

@ publication = N'pub1 ',

@ 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 = 1

-Додамо в список доступу публікації ім'я входа._grant_publication_access

@ publication = N'pub1 ',

@ login = N'sa'_grant_publication_access

@ publication = N'pub1 ',

@ login = N'NT AUTHORITY сістема'_grant_publication_access

@ publication = N'pub1 ',

@ login = N'redwhite-ПК redwhite'_grant_publication_access

@ publication = N'pub1 ',

@ login = N'NT SERVICE MSSQL $ MSSQLSERVERSERJ1'_grant_publication_access

@ publication = N'pub1 ',

@ login = N'NT SERVICE SQLAgent $ MSSQLSERVERSERJ1'_grant_publication_access

@ publication = N'pub1 ',

@ login = N'distributor_admin '

- Додавання транзакційних статей для всіх таблиць [kp_bd] _addarticle

@ publication = N'pub1 ',

@ article = N'врач ',

@ source_owner = N'dbo ',

@ source_object = N'врач ',

@ type = N'logbased ',

@ description = N'', @ creation_script = N'',

@ pre_creation_cmd = N'drop ',

@ schema_option = 0x0000000008035CDF,

@ identityrangemanagementoption = N'none ', @ destination_table = N&#...