---------------------------------- Starting execution of PRE_MSDB.SQL ---------------------------------- ----------------------------------------- Starting execution of PRE_SQLAGENT100.SQL ----------------------------------------- (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator. Creating table temp_sysjobschedules (0 rows affected) (0 rows affected) Alter table sysdownloadlist... Alter table sysjobhistory... (0 rows affected) Alter table systargetservers... Alter table sysjobsteps... ----------------------------------------- Execution of PRE_SQLAGENT100.SQL complete ----------------------------------------- DMF pre-upgrade steps... DC pre-upgrade steps... Check if Data collector config table exists... Data Collector state before upgrade: 0 (1 row affected) pre_dc100::Check if syscollector_collection_sets_internal table exists... pre_dc100::Capturing Collection set status in temp table... (4 rows affected) Deleting cached auto-generated T-SQL Data Collection packages from msdb... (0 rows affected) End of DC pre-upgrade steps. DAC pre-upgrade steps... Starting DAC pre-upgrade steps ... End of DAC pre-upgrade steps. ---------------------------------- Starting execution of MSDB.SQL ---------------------------------- Checking the size of MSDB... ---------------------------------- Finished execution of MSDB.SQL ---------------------------------- ----------------------------------------- Starting execution of MSDB_VERSIONING.SQL ----------------------------------------- ----------------------------------------- Finished execution of MSDB_VERSIONING.SQL ----------------------------------------- Creating procedure sp_agent_add_job... Creating procedure sp_agent_delete_job... Creating procedure sp_agent_add_jobstep... Creating procedure sp_agent_start_job... Creating procedure sp_agent_get_jobstep... Creating procedure sp_agent_log_job_history... Creating procedure sp_agent_write_sysjobstep_log... Creating table syssubsystems... Creating view sysproxyloginsubsystem_view... Creating trigger trig_sysoriginatingservers_delete... Creating view sysoriginatingservers_view... Creating trigger trig_sysjobs_insert_update... Creating view sysjobs_view... Creating trigger trig_sysschedules_insert_update... Creating view sysschedules_localserver_view... Creating view systargetservers_view... Creating view sysalerts_performance_counters_view... Creating function SQLAGENT_SUSER_SNAME ... Creating function SQLAGENT_SUSER_SID ... Creating procedure SP_SQLAGENT_IS_SRVROLEMEMBER... Creating procedure sp_get_traceflag_status_internal... Creating procedure sp_verify_category_identifiers... Creating function agent_datetime... Creating procedure sp_verify_proxy_identifiers... Creating procedure sp_verify_credential_identifiers... Creating procedure sp_verify_subsystems... Creating procedure sp_verify_subsystem_identifiers... Creating procedure sp_verify_login_identifiers... Creating procedure sp_verify_proxy... Creating procedure sp_add_proxy... Creating procedure sp_delete_proxy... Creating procedure sp_update_proxy... Creating procedure sp_sqlagent_is_member... Creating procedure sp_verify_proxy_permissions... Creating procedure sp_help_proxy... Creating procedure sp_get_proxy_properties... Creating procedure sp_grant_proxy_to_subsystem... Creating procedure sp_grant_login_to_proxy... Creating procedure sp_revoke_login_from_proxy... Creating procedure sp_revoke_proxy_from_subsystem... Creating procedure sp_enum_proxy_for_subsystem... Creating procedure sp_enum_login_for_proxy... Creating procedure sp_reassign_proxy... Creating procedure sp_sqlagent_get_startup_info... Creating procedure sp_sqlagent_update_agent_xps... Creating procedure sp_sqlagent_has_server_access... Creating procedure sp_sqlagent_get_perf_counters... Msg 468, Level 16, State 9, Procedure sp_sqlagent_get_perf_counters, Line 91 [Batch Start Line 5258] Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Polish_CI_AS" in the equal to operation. Creating procedure sp_sqlagent_notify... Creating procedure sp_is_sqlagent_starting... Creating procedure sp_verify_job_identifiers... Creating procedure sp_verify_schedule_identifiers... Creating procedure sp_verify_jobproc_caller... Creating procedure sp_downloaded_row_limiter... Creating procedure sp_post_msx_operation... Creating procedure sp_verify_performance_condition... Creating procedure sp_verify_job_date... Creating procedure sp_verify_job_time... Creating procedure sp_verify_alert... Creating procedure sp_update_alert... Creating procedure sp_delete_job_references... Creating procedure sp_delete_all_msx_jobs... Creating procedure sp_generate_target_server_job_assignment_sql... Creating procedure sp_generate_server_description... Creating procedure sp_msx_set_account... Creating procedure sp_msx_get_account... Creating procedure sp_delete_operator... Creating procedure sp_msx_defect... Creating procedure sp_msx_enlist... Creating procedure sp_delete_targetserver... Creating procedure sp_enlist_tsx Creating procedure sp_get_sqlagent_properties... Create procedure sp_set_sqlagent_properties... Creating procedure sp_add_targetservergroup... Creating procedure sp_update_targetservergroup... Creating procedure sp_delete_targetservergroup... Creating procedure sp_help_targetservergroup... Creating procedure sp_add_targetsvgrp_member... Creating procedure sp_delete_targetsvrgrp_member... Creating procedure sp_verify_category... Creating procedure sp_add_category... Creating procedure sp_update_category... Creating procedure sp_delete_category... Creating procedure sp_help_category... Creating procedure sp_help_targetserver... Creating procedure sp_resync_targetserver... Creating procedure sp_purge_jobhistory... Creating procedure sp_help_jobhistory... Creating procedure sp_add_jobserver... Creating procedure sp_delete_jobserver... Creating procedure sp_help_jobserver... Creating procedure sp_help_downloadlist... Creating procedure sp_enum_sqlagent_subsystems_internal... Creating procedure sp_enum_sqlagent_subsystems... Creating procedure sp_verify_subsystem... Creating procedure sp_verify_schedule... Creating procedure sp_add_schedule... Creating procedure sp_attach_schedule ... Creating procedure sp_detach_schedule ... Creating procedure sp_update_replication_job_parameter... Creating procedure sp_update_schedule ... Creating procedure sp_delete_schedule ... Creating procedure sp_get_jobstep_db_username... Creating procedure sp_verify_jobstep... Creating procedure sp_add_jobstep_internal... Creating procedure sp_add_jobstep... Creating procedure sp_update_jobstep... Creating procedure sp_delete_jobstep... Creating procedure sp_help_jobstep... Creating procedure sp_write_sysjobstep_log... Creating procedure sp_help_jobsteplog... Creating procedure sp_delete_jobsteplog... Creating procedure sp_get_schedule_description... Creating procedure sp_add_jobschedule... Creating procedure sp_update_jobschedule... Creating procedure sp_delete_jobschedule... Creating procedure sp_help_schedule... Creating procedure sp_help_jobschedule... Creating procedure sp_verify_job... Creating procedure sp_add_job... Creating procedure sp_update_job... Creating procedure sp_delete_job... Creating procedure sp_get_composite_job_info... Creating procedure sp_help_job... Creating procedure sp_help_jobcount... Creating procedure sp_help_jobs_in_schedule... Creating procedure sp_manage_jobs_by_login... Creating procedure sp_apply_job_to_targets... Creating procedure sp_remove_job_from_targets... Creating procedure sp_get_job_alerts... Creating procedure sp_start_job... Creating procedure sp_stop_job... Creating procedure sp_cycle_agent_errorlog... Creating procedure sp_get_chunked_jobstep_params... Creating procedure sp_check_for_owned_jobs... Creating procedure sp_check_for_owned_jobsteps... Creating procedure sp_sqlagent_refresh_job... Creating procedure sp_jobhistory_row_limiter... Creating procedure [dbo].[sp_sqlagent_set_job_completion_state]... Creating procedure [dbo].[sp_sqlagent_set_jobstep_completion_state]... Creating procedure [dbo].[sp_sqlagent_create_jobactivity]... Creating procedure [dbo].[sp_sqlagent_update_jobactivity_next_scheduled_date]... Creating procedure [dbo].[sp_sqlagent_update_jobactivity_requested_date]... Creating procedure [dbo].[sp_sqlagent_update_jobactivity_queued_date]... Creating procedure [dbo].[sp_sqlagent_update_jobactivity_start_execution_date]... Creating procedure sp_sqlagent_log_jobhistory... Creating procedure sp_sqlagent_check_msx_version... Creating procedure sp_sqlagent_probe_msx... Creating procedure sp_set_local_time... Creating procedure sp_multi_server_job_summary... Creating procedure sp_target_server_summary... Creating [legacy] procedure sp_uniquetaskname... Creating [legacy] procedure sp_addtask... Creating [legacy] procedure sp_droptask... Creating trigger trig_targetserver_insert... Creating procedure sp_add_alert_internal... Creating procedure sp_add_alert... Creating procedure sp_delete_alert... Creating procedure sp_help_alert... Creating procedure sp_verify_operator... Creating procedure sp_add_operator... Creating procedure sp_update_operator... Creating procedure sp_help_operator... Creating procedure sp_help_operator_jobs... Creating procedure sp_verify_operator_identifiers... Creating procedure sp_notify_operator... Creating procedure sp_verify_notification... Creating procedure sp_add_notification... Creating procedure sp_update_notification... Creating procedure sp_delete_notification... Creating procedure sp_help_notification... Creating procedure sp_help_jobactivity... Creating trigger trig_notification_ins_or_upd... Creating trigger trig_notification_delete... Setting object permissions... The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. Creating procedure sp_sem_add_message... Creating procedure sp_sem_drop_message... Creating procedure sp_get_message_description... Creating procedure sp_convert_jobid_to_char... Creating view sysmail_allitems... Creating view sysmail_sentitems... Creating view sysmail_unsentitems... Creating view sysmail_faileditems... Creating sysmail_delete_mailitems_sp Creating view sysmail_mailattachments... Creating view sysmail_event_log... Creating sysmail_delete_log_sp Creating trigger trig_sysmail_profile... Creating trigger trig_principalprofile... Creating trigger trig_sysmail_account... Creating trigger trig_sysmail_profileaccount... Creating trigger trig_sysmail_profile_delete... Creating trigger trig_sysmail_servertype... Creating trigger trig_sysmail_server... Creating trigger trig_sysmail_configuration... Creating procedure sysmail_verify_accountparams_sp... Creating procedure sysmail_verify_addressparams_sp... Creating procedure sysmail_verify_principal_sp... Creating procedure sysmail_verify_profile_sp... Creating procedure sysmail_verify_account_sp... Creating procedure sysmail_add_profile_sp... Creating procedure sysmail_update_profile_sp... Creating procedure sysmail_delete_profile_sp... Creating procedure sysmail_help_profile_sp... Creating procedure sysmail_create_user_credential_sp... Creating procedure sysmail_alter_user_credential_sp... Creating procedure sysmail_drop_user_credential_sp... Creating procedure sysmail_add_account_sp... Creating procedure sysmail_update_account_sp... Creating procedure sysmail_delete_account_sp... Creating procedure sysmail_help_account_sp... Creating procedure sysmail_help_admin_account_sp... Creating procedure sysmail_add_profileaccount_sp... Creating procedure sysmail_update_profileaccount_sp... Creating procedure sysmail_delete_profileaccount_sp... Creating procedure sysmail_help_profileaccount_sp... Creating procedure sysmail_configure_sp... Creating procedure sysmail_help_configure_sp... Creating procedure sysmail_help_configure_value_sp... Creating procedure sysmail_add_principalprofile_sp... Creating procedure sysmail_update_principalprofile_sp... Creating procedure sysmail_delete_principalprofile_sp... Creating procedure sysmail_help_principalprofile_sp... Creating sysmail_logmailevent_sp Creating sysmail_start_sp Creating sysmail_stop_sp Creating sysmail_help_status_sp Creating sysmail_help_queue_sp Creating sp_SendMailMessage Creating sp_isprohibited Creating sp_SendMailQueues Creating sp_ProcessResponse Creating sp_MailItemResultSets Creating sp_process_DialogTimer Creating sp_readrequest Creating sp_GetAttachmentData Creating sp_RunMailQuery Creating sp_send_dbmail Creating sp_ExternalMailQueueListener Creating sp_sysmail_activate Dropping Database Mail MESSAGES, CONTRACTS, QUEUES AND SERVICES... Dropping SERVICE InternalMailService Dropping SERVICE ExternalMailService Dropping QUEUE InternalMailQueue Dropping QUEUE ExternalMailQueue Dropping CONTRACT [//www.microsoft.com/databasemail/contracts/SendMail/v1.0] Dropping MESSAGE TYPE [{//www.microsoft.com/databasemail/messages}SendMail] Dropping MESSAGE TYPE [{//www.microsoft.com/databasemail/messages}SendMailStatus] Creating MESSAGES, CONTRACTS, QUEUES AND SERVICES... Creating MESSAGE TYPE [{//www.microsoft.com/databasemail/messages}SendMail] Creating CONTRACT [//www.microsoft.com/databasemail/contracts/SendMail/v1.0] Creating QUEUE InternalMailQueue Creating QUEUE ExternalMailQueue Creating SERVICE InternalMailService ON QUEUE InternalMailQueue Creating SERVICE ExternalMailService ON QUEUE ExternalMailQueue Creating procedure sp_maintplan_delete_log... Creating procedure sp_maintplan_delete_subplan... Creating procedure sp_maintplan_update_subplan_tsx... Creating procedure sp_maintplan_subplans_by_job... Creating procedure sp_maintplan_open_logentry... Creating procedure sp_maintplan_close_logentry... Creating procedure sp_maintplan_update_log... Creating procedure sp_maintplan_update_subplan... Creating procedure sp_maintplan_delete_plan... Creating procedure sp_maintplan_start... No foreign keys reference table 'sysdbmaintplan_history', or you do not have permissions on referencing tables. (8 rows affected) Creating procedure sp_clear_dbmaintplan_by_db... Creating procedure sp_add_maintenance_plan... Creating procedure sp_delete_maintenance_plan... Creating procedure sp_add_maintenance_plan_db... Creating procedure sp_delete_maintenance_plan_db... Creating procedure sp_add_maintenance_plan_job... Creating procedure sp_delete_maintenance_plan_job... Creating procedure sp_help_maintenance_plan... Creating procedure sp_delete_database_backuphistory... Creating procedure sp_delete_backuphistory... Creating procedure sp_add_log_shipping_monitor_jobs... Creating procedure sp_add_log_shipping_primary... Creating procedure sp_add_log_shipping_secondary... Creating procedure sp_delete_log_shipping_monitor_jobs... Creating procedure sp_delete_log_shipping_primary... Creating sp_delete_log_shipping_secondary... Creating procedure sp_log_shipping_in_sync... Creating procedure sp_log_shipping_get_date_from_file... Creating procedure sp_get_log_shipping_monitor_info... Creating procedure sp_update_log_shipping_monitor_info... Creating procedure sp_delete_log_shipping_monitor_info... Creating procedure sp_remove_log_shipping_monitor_account... Creating procedure sp_log_shipping_monitor_backup... Creating procedure sp_log_shipping_monitor_restore... Creating procedure sp_change_monitor_role... Creating procedure sp_create_log_shipping_monitor_account... Creating view sysmaintplan_plans... The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. Create dc_operator role... Create dc_admin role... Create dc_proxy role... Create loginless user that has ownership of data collector agent-related securables... Creating view [dbo].[syscollector_config_store]... Creating procedure [dbo].[sp_syscollector_verify_collector_state]... Creating procedure [dbo].[sp_syscollector_set_warehouse_instance_name]... Creating procedure [dbo].[sp_syscollector_set_warehouse_database_name]... Creating procedure [dbo].[sp_syscollector_set_cache_directory]... Creating procedure [dbo].[sp_syscollector_set_cache_window]... Creating procedure [dbo].[sp_syscollector_get_warehouse_connection_string]... Creating procedure [dbo].[sp_syscollector_snapshot_dm_exec_requests_internal]... Creating procedure [dbo].[sp_syscollector_snapshot_dm_exec_query_stats_internal]... Creating procedure [dbo].[sp_syscollector_get_query_activity_collection_item_params]... Creating procedure [dbo].[sp_syscollector_snapshot_dm_exec_requests]... Creating procedure [dbo].[sp_syscollector_snapshot_dm_exec_query_stats]... Creating function [dbo].[fn_syscollector_highest_incompatible_mdw_version]... Creating view [dbo].[syscollector_collection_sets]... Creating procedure [dbo].[sp_syscollector_verify_collection_set]... Creating procedure [dbo].[sp_syscollector_create_jobs]... Creating procedure [dbo].[sp_syscollector_create_collection_set]... Creating procedure [dbo].[sp_syscollector_update_job_proxy]... Creating procedure [dbo].[sp_syscollector_update_collection_set_internal]... Creating procedure [dbo].[sp_syscollector_update_collection_set]... Creating procedure [dbo].[sp_syscollector_configure_sql_dumper]... Creating function [dbo].[fn_syscollector_get_package_path]... Creating view [dbo].[syscollector_collector_types]... Creating procedure [dbo].[sp_syscollector_verify_collector_type]... Creating procedure [dbo].[sp_syscollector_create_collector_type]... Creating procedure [dbo].[sp_syscollector_update_collector_type]... Creating procedure [dbo].[sp_syscollector_validate_xml]... Creating view [dbo].[syscollector_collection_items]... Creating procedure [dbo].[sp_syscollector_delete_collector_type]... Creating procedure [dbo].[sp_syscollector_verify_collection_item]... Creating procedure [dbo].[sp_syscollector_create_collection_item]... Creating procedure [dbo].[sp_syscollector_update_collection_item_internal]... Creating procedure [dbo].[sp_syscollector_update_collection_item]... Creating procedure [dbo].[sp_syscollector_delete_collection_item_internal]... Creating procedure [dbo].[sp_syscollector_delete_collection_item]... Creating procedure [dbo].[sp_syscollector_start_collection_set]... Creating procedure [dbo].[sp_syscollector_stop_collection_set]... Creating procedure [dbo].[sp_syscollector_get_collection_set_execution_status]... Creating procedure [dbo].[sp_syscollector_upload_collection_set]... Creating procedure [dbo].[sp_syscollector_run_collection_set]... Creating trigger [dbo].[syscollector_collection_set_is_running_update_trigger] on [dbo].[syscollector_collection_sets_internal] Creating stored procedure syscollector_stop_collection_set_jobs... Creating stored procedure syscollector_start_collection_set_jobs... Creating view syscollector_execution_log... Creating procedure [dbo].[sp_syscollector_delete_jobs]... Creating view syscollector_execution_stats... Creating stored procedure sp_syscollector_verify_event_log_id... Creating stored procedure sp_syscollector_event_oncollectionstart... Creating stored procedure sp_syscollector_event_oncollectionstop... Creating stored procedure sp_syscollector_event_oncollectionbegin... Creating stored procedure sp_syscollector_event_oncollectionend... Creating stored procedure sp_syscollector_event_onpackagebegin... Creating stored procedure sp_syscollector_event_onpackageend... Creating stored procedure sp_syscollector_event_onpackageupdate... Creating stored procedure sp_syscollector_event_onerror... Creating stored procedure sp_syscollector_event_onstatsupdate... Creating function [dbo].[fn_syscollector_find_collection_set_root] ... Creating function [dbo].[fn_syscollector_get_execution_log_tree] ... Creating function [dbo].[fn_syscollector_get_execution_stats] ... Creating function [dbo].[fn_syscollector_get_execution_details] ... Creating view syscollector_execution_log_full... Creating procedure [dbo].[sp_syscollector_delete_execution_log_tree] ... Creating procedure [dbo].[sp_syscollector_delete_collection_set_internal]... Creating procedure [dbo].[sp_syscollector_delete_collection_set]... Creating stored procedure sp_syscollector_purge_collection_logs... Creating procedure [dbo].[sp_syscollector_enable_collector]... Creating procedure [dbo].[sp_syscollector_disable_collector]... Creating procedure [dbo].[sp_syscollector_get_trace_info]... Creating procedure [dbo].[sp_syscollector_text_query_plan_lookpup]... Creating procedure [dbo].[sp_syscollector_sql_text_lookup]... Installing out of the box Collector objects Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install. Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install. (1 row affected) (1 row affected) Creating SSIS folders... Creating procedure [dbo].[sp_syscollector_get_instmdw]... Creating procedure [dbo].[sp_syscollector_upload_instmdw]... Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\SqlTraceCollect.dtsx Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\SqlTraceCollect.dtsx (1 row affected) Loaded 37732 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\SqlTraceCollect.dtsx' Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\SqlTraceUpload.dtsx Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\SqlTraceUpload.dtsx (1 row affected) Loaded 693081 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\SqlTraceUpload.dtsx' Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\TSQLQueryCollect.dtsx Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\TSQLQueryCollect.dtsx (1 row affected) Loaded 20989 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\TSQLQueryCollect.dtsx' Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\TSQLQueryUpload.dtsx Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\TSQLQueryUpload.dtsx (1 row affected) Loaded 16576 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\TSQLQueryUpload.dtsx' Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\PerfCountersCollect.dtsx Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\PerfCountersCollect.dtsx (1 row affected) Loaded 63074 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\PerfCountersCollect.dtsx' Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\PerfCountersUpload.dtsx Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\PerfCountersUpload.dtsx (1 row affected) Loaded 164276 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\PerfCountersUpload.dtsx' Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\QueryActivityCollect.dtsx Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\QueryActivityCollect.dtsx (1 row affected) Loaded 305787 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\QueryActivityCollect.dtsx' Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\QueryActivityUpload.dtsx Uploading data collector package from disk: C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\QueryActivityUpload.dtsx (1 row affected) Loaded 1647171 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL15.AKMSSQLPROD2\MSSQL\Install\QueryActivityUpload.dtsx' Creating or updating Collection Types... Updating Performance counters collector type (1 row affected) (1 row affected) Updating TSQL Query collector type (1 row affected) (1 row affected) Creating trigger [dbo].[syscollector_collection_item_parameter_update_trigger] on [dbo].[syscollector_collection_items_internal] Creating trigger [dbo].[syscollector_tsql_query_collector_delete_trigger] on [dbo].[syscollector_tsql_query_collector] Creating procedure [dbo].[sp_syscollector_create_tsql_query_collector]... Creating procedure [dbo].[sp_syscollector_get_tsql_query_collector_package_ids]... Creating procedure [dbo].[sp_syscollector_cleanup_collector] ... Updating SQL Trace collector type (1 row affected) (1 row affected) Updating Query Activity Collector Type (1 row affected) (1 row affected) Creating data collector schedules Creating system Collection Sets... Updating system Collection Set "Disk Usage"... (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) Updating Collection Item "Disk Usage - Data Files"... (0 rows affected) (1 row affected) (1 row affected) Updating Collection Item "Disk Usage - Log Files"... (0 rows affected) (1 row affected) (1 row affected) (1 row affected) Updating system Collection Set "Server Activity"... (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) Updating Collection Item "Server Activity - DMV Snapshots"... (0 rows affected) (1 row affected) (1 row affected) Updating Collection Item "Server Activity - Performance Counters"... (0 rows affected) (1 row affected) (1 row affected) (1 row affected) Updating system Collection Set "Query Statistics"... (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) Updating Collection Item "Query Statistics - Query Activity"... (0 rows affected) (1 row affected) (1 row affected) (1 row affected) Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install. Granting permissions to data collector roles... (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) Object "[dbo].[sp_syspolicy_add_target_set_condition_reference]" does not exist, will not drop Object "[dbo].[sp_syspolicy_update_target_set_condition_reference]" does not exist, will not drop Object "[dbo].[syspolicy_target_set_condition_references]" does not exist, will not drop Object "[dbo].[syspolicy_update_condition_trigger]" does not exist, will not drop Executing "drop TRIGGER [dbo].[syspolicy_validate_events]" Done dropping all DMF and Shared Registered Server procedures (0 rows affected) Creating trigger [sysmanagement_delete_shared_server_group_trigger]... Creating view [dbo].[sysmanagement_shared_server_groups]... Creating view [dbo].[sysmanagement_shared_registered_servers]... Creating procedure [dbo].[sp_sysmanagement_verify_shared_server_type]... Creating procedure [dbo].[sp_sysmanagement_add_shared_server_group]... Creating procedure [dbo].[sp_sysmanagement_add_shared_registered_server]... Creating procedure [dbo].[sp_sysmanagement_delete_shared_server_group]... Creating procedure [dbo].[sp_sysmanagement_delete_shared_registered_server]... Creating procedure [dbo].[sp_sysmanagement_move_shared_server_group]... Creating procedure [dbo].[sp_sysmanagement_move_shared_registered_server]... Creating procedure [dbo].[sp_sysmanagement_update_shared_server_group]... Creating procedure [dbo].[sp_sysmanagement_update_shared_registered_server]... Creating procedure [dbo].[sp_sysmanagement_rename_shared_server_group]... Creating procedure [dbo].[sp_sysmanagement_rename_shared_registered_server]... (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (0 rows affected) (0 rows affected) (100 rows affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) Creating view [dbo].[syspolicy_conditions]... Creating procedure [dbo].[sp_syspolicy_add_condition]... Creating procedure [dbo].[sp_syspolicy_verify_condition_identifiers]... Creating procedure [dbo].[sp_syspolicy_update_condition]... Creating procedure [dbo].[sp_syspolicy_delete_condition]... Creating procedure [dbo].[sp_syspolicy_rename_condition]... Creating view [dbo].[syspolicy_policy_categories]... Creating view [dbo].[syspolicy_object_sets]... Creating procedure [dbo].[sp_syspolicy_verify_object_set_identifiers]... Creating procedure [dbo].[sp_syspolicy_verify_object_set_references]... Creating procedure [dbo].[sp_syspolicy_add_object_set]... Creating procedure [dbo].[sp_syspolicy_delete_object_set]... Creating procedure [dbo].[sp_syspolicy_create_job]... Creating function [dbo].[fn_syspolicy_get_ps_command] ... Creating trigger [dbo].[syspolicy_insert_job_create_trigger] on [dbo].[syspolicy_policies_internal] Creating trigger [dbo].[syspolicy_update_job_update_trigger] on [dbo].[syspolicy_policies_internal] Creating trigger [dbo].[syspolicy_insert_policy_trigger] on [dbo].[syspolicy_policies_internal] Creating trigger [dbo].[syspolicy_update_policy_trigger] on [dbo].[syspolicy_policies_internal] Creating trigger [dbo].[syspolicy_delete_job_delete_trigger] on [dbo].[syspolicy_policies_internal] Creating trigger [dbo].[syspolicy_instead_delete_policy_trigger] on [dbo].[syspolicy_policies_internal] Creating view [dbo].[syspolicy_policies]... Creating trigger syspolicy_insert_condition_trigger... Creating trigger dbo.syspolicy_for_update_condition_trigger... Creating trigger syspolicy_after_update_condition_trigger... Creating procedure [dbo].[sp_syspolicy_verify_policy_category_identifiers]... Creating procedure [dbo].[sp_syspolicy_add_policy_category]... Creating procedure [dbo].[sp_syspolicy_delete_policy_category]... Creating procedure [dbo].[sp_syspolicy_rename_policy_category]... Creating procedure [dbo].[sp_syspolicy_update_policy_category]... Creating procedure [dbo].[sp_syspolicy_add_policy]... Creating procedure [dbo].[sp_syspolicy_verify_policy_identifiers]... Creating procedure [dbo].[sp_syspolicy_rename_policy]... Creating procedure [dbo].[sp_syspolicy_update_policy]... Creating procedure [dbo].[sp_syspolicy_delete_policy]... Creating function [dbo].[syspolicy_fn_get_bad_filters]... Creating view [dbo].[syspolicy_target_sets]... Creating view [dbo].[syspolicy_target_set_levels]... Creating procedure [dbo].[sp_syspolicy_add_target_set]... Creating procedure [dbo].[sp_syspolicy_update_target_set]... Creating procedure [dbo].[sp_syspolicy_delete_target_set]... Creating procedure [dbo].[sp_syspolicy_add_target_set_level]... Creating procedure [dbo].[sp_syspolicy_update_target_set_level]... Creating function [dbo].[syspolicy_fn_eventing_filter] Creating function [dbo].[syspolicy_fn_filter_complete] Creating trigger [dbo].[syspolicy_insert_target_set_level_trigger] on [dbo].[syspolicy_target_set_levels_internal] Creating trigger [dbo].[syspolicy_update_target_set_level_trigger] on [dbo].[syspolicy_target_set_levels_internal] Creating trigger [dbo].[syspolicy_insert_target_set_trigger] on [dbo].[syspolicy_target_sets_internal] Creating trigger [dbo].[syspolicy_delete_target_set_trigger] on [dbo].[syspolicy_target_sets_internal] Creating view [dbo].[syspolicy_policy_category_subscriptions]... Creating procedure [dbo].[sp_syspolicy_add_policy_category_subscription]... Creating procedure [dbo].[sp_syspolicy_update_policy_category_subscription]... Creating procedure [dbo].[sp_syspolicy_delete_policy_category_subscription]... Creating trigger [syspolicy_update_system_health_state]... Creating procedure [dbo].[sp_syspolicy_log_policy_execution_start]... Creating procedure [dbo].[sp_syspolicy_log_policy_execution_end]... Creating procedure [dbo].[sp_syspolicy_log_policy_execution_detail]... Creating procedure [dbo].[sp_syspolicy_delete_policy_execution_history]... Creating procedure [dbo].[sp_syspolicy_mark_system]... Creating function [dbo].[syspolicy_fn_get_type_name]... Creating procedure [dbo].[sp_syspolicy_dispatch_event]... Dropping service [syspolicy_event_listener]... Dropping queue [syspolicy_event_queue]... Creating queue [syspolicy_event_queue]... Creating service [syspolicy_event_listener]... Creating view [dbo].[syspolicy_configuration] ... Creating procedure [dbo].[sp_syspolicy_set_config_history_retention] ... Creating procedure [dbo].[sp_syspolicy_set_log_on_success] ... Creating procedure [dbo].[sp_syspolicy_set_config_enabled] ... Creating procedure [dbo].[sp_syspolicy_configure] ... Creating function [dbo].[fn_syspolicy_is_automation_enabled] ... Creating procedure [dbo].[sp_syspolicy_repair_policy_automation] ... Creating procedure [dbo].[sp_syspolicy_purge_history] ... Creating procedure [dbo].[sp_syspolicy_create_purge_job] ... Creating procedure [dbo].[sp_syspolicy_purge_health_state] ... DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. Hook up the activation procedure to the queue... (0 rows affected) (0 rows affected) Dropping Function [dbo].[fn_sysdac_get_currentusername] Creating Function [dbo].[fn_sysdac_is_dac_creator]... Creating Function [dbo].[fn_sysdac_is_login_creator]... Creating Function [dbo].[fn_sysdac_is_currentuser_sa]... Creating Function [dbo].[fn_sysdac_get_username]... Creating Function [dbo].[fn_sysdac_get_currentusername]... Creating View [dbo].[sysdac_instances]... Creating procedure [dbo].[sp_sysdac_ensure_dac_creator]... Creating procedure [dbo].[sp_sysdac_add_instance]... Creating procedure [dbo].[sp_sysdac_update_instance]... Creating procedure [dbo].[sp_sysdac_add_history_entry]... Creating procedure [dbo].[sp_sysdac_delete_instance]... Creating procedure [dbo].[sp_sysdac_delete_history]... Creating procedure [dbo].[sp_sysdac_upgrade_instance]... Creating procedure [dbo].[sp_sysdac_drop_database]... Creating procedure [dbo].[sp_sysdac_rename_database]... Creating procedure [dbo].[sp_sysdac_setreadonly_database]... Creating procedure [dbo].[sp_sysdac_update_history_entry]... Creating procedure [dbo].[sp_sysdac_resolve_pending_entry]... Creating procedure [dbo].[sp_sysdac_rollback_committed_step]... Creating procedure [dbo].[sp_sysdac_rollback_pending_object]... Creating procedure [dbo].[sp_sysdac_rollback_all_pending_objects]... ------------------------------------ Execution of InstDac.SQL complete ------------------------------------ ----------------------------------------- Starting execution of EXTENSIBILITY.SQL ----------------------------------------- ----------------------------------------- Finished execution of EXTENSIBILITY.SQL ----------------------------------------- Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install. Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install. (1 row affected) Creating view [dbo].[sysutility_ucp_configuration]... Creating view [dbo].[sysutility_ucp_policy_configuration]... Creating [dbo].[fn_sysutility_get_is_instance_ucp] Dropping table [dbo].[sysutility_ucp_dacs_stub] Creating table [sysutility_ucp_dacs_stub] Dropping table [dbo].[sysutility_ucp_volumes_stub] Creating table [sysutility_ucp_latest_volumes_stub] Dropping table [dbo].[sysutility_ucp_computers_stub] Creating table [sysutility_ucp_computers_stub] Dropping table [dbo].[sysutility_ucp_smo_servers_stub] Creating table [dbo].[sysutility_ucp_smo_servers_stub] Dropping table [dbo].[sysutility_ucp_databases_stub] Creating table [dbo].[sysutility_ucp_databases_stub] Dropping table [dbo].[sysutility_ucp_filegroups_stub] Creating table [dbo].[sysutility_ucp_filegroups_stub] Dropping table [dbo].[sysutility_ucp_datafiles_stub] Creating table [dbo].[sysutility_ucp_datafiles_stub] Dropping table [dbo].[sysutility_ucp_logfiles_stub] Creating table [dbo].[sysutility_ucp_logfiles_stub] Dropping table [dbo].[sysutility_ucp_cpu_utilization_stub] Creating table [dbo].[sysutility_ucp_cpu_utilization_stub] Dropping table [dbo].[sysutility_ucp_space_utilization_stub] Creating table [dbo].[sysutility_ucp_space_utilization_stub] Creating [dbo].[sp_sysutility_ucp_recreate_synonym_internal] procedure Creating procedure [dbo].[sp_sysutility_ucp_initialize_mdw] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_computers] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_computers] FOR [msdb].[dbo].[sysutility_ucp_computers_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_volumes] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_volumes] FOR [msdb].[dbo].[sysutility_ucp_volumes_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_dacs] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_dacs] FOR [msdb].[dbo].[sysutility_ucp_dacs_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_smo_servers] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_smo_servers] FOR [msdb].[dbo].[sysutility_ucp_smo_servers_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_databases] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_databases] FOR [msdb].[dbo].[sysutility_ucp_databases_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_filegroups] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_filegroups] FOR [msdb].[dbo].[sysutility_ucp_filegroups_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_datafiles] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_datafiles] FOR [msdb].[dbo].[sysutility_ucp_datafiles_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_logfiles] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_logfiles] FOR [msdb].[dbo].[sysutility_ucp_logfiles_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_cpu_utilization] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_cpu_utilization] FOR [msdb].[dbo].[sysutility_ucp_cpu_utilization_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_space_utilization] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_space_utilization] FOR [msdb].[dbo].[sysutility_ucp_space_utilization_stub] Creating procedure [dbo].[sp_sysutility_mi_configure_proxy_account] Creating procedure [dbo].[sp_sysutility_ucp_provision_proxy_account] Creating procedure [dbo].[sp_sysutility_mi_validate_proxy_account] Creating [dbo].[fn_sysutility_mi_get_validate_wmi_script] function Creating procedure [dbo].[sp_sysutility_mi_create_job_validate_wmi] Creating procedure [dbo].[sp_sysutility_mi_create_cache_directory] Creating [dbo].[sysutility_mi_configuration] view Creating [dbo].[sp_sysutility_mi_add_ucp_registration] procedure Creating [dbo].[sp_sysutility_mi_remove_ucp_registration] procedure Creating [dbo].[fn_sysutility_ucp_get_instance_is_mi] function Dropping [dbo].[sysutility_mi_dac_execution_statistics_internal] table Creating [dbo].[sysutility_mi_dac_execution_statistics_internal] table Dropping table [dbo].[sysutility_mi_session_statistics_internal] Creating table [dbo].[sysutility_mi_session_statistics_internal] Creating [dbo].[sp_sysutility_mi_collect_dac_execution_statistics_internal] procedure Creating [dbo].[sp_sysutility_mi_get_dac_execution_statistics_internal] procedure Creating [dbo].[fn_sysutility_mi_get_batch_manifest] function (5 rows affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (0 rows affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) Deleting collection set "Utility Information"... (1 row affected) (1 row affected) Creating system Collection Set "Utility Information"... (1 row affected) (1 row affected) Creating Collection Item "Utility Information - Managed Instance"... (1 row affected) (1 row affected) (1 row affected) Creating [dbo].[fn_sysutility_mi_get_data_collector_status] procedure Creating procedure [dbo].[sp_sysutility_mi_upload] Creating [dbo].[fn_sysutility_mi_get_collect_script] function Creating [dbo].[sp_sysutility_mi_initialize_collection] procedure Creating [dbo].[sp_sysutility_mi_disable_collection] procedure Creating function [dbo].[fn_sysutility_ucp_get_edition_is_ucp_capable_internal] Creating procedure [dbo].[sp_sysutility_ucp_validate_prerequisites] Creating procedure [dbo].[sp_sysutility_ucp_create] Creating procedure [dbo].[sp_sysutility_mi_validate_enrollment_preconditions] Creating procedure [dbo].[sp_sysutility_mi_enroll] Creating view [dbo].[sysutility_ucp_managed_instances]... Creating procedure [dbo].[sp_sysutility_ucp_add_mi] Creating procedure [dbo].[sp_sysutility_ucp_initialize] Creating procedure [dbo].[sp_sysutility_ucp_update_utility_configuration] Creating procedure [dbo].[fn_sysutility_ucp_accepts_upload_schema_version] Creating procedure [dbo].[sp_sysutility_ucp_add_policy] Creating procedure [dbo].[sp_sysutility_ucp_delete_policy] Creating procedure [dbo].[sp_sysutility_ucp_update_policy] (12 rows affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (24 rows affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) Creating procedure dbo.sp_sysutility_ucp_get_policy_violations Creating function dbo.fn_encode_sqlname_for_powershell Creating procedure dbo.sp_sysutility_ucp_delete_policy_history Creating function dbo.[fn_sysutility_ucp_get_global_health_policy] Creating function dbo.[fn_sysutility_ucp_get_applicable_policy] Creating function [fn_sysutility_ucp_get_aggregated_failure_count] Creating function [fn_sysutility_ucp_get_policy_violations] Creating function [fn_sysutility_ucp_get_file_space_utilization_history] Creating function [fn_sysutility_ucp_get_cpu_utilization_history] Creating view [dbo].[sysutility_ucp_deployed_dacs] Creating view [dbo].[sysutility_ucp_computers] Creating view [dbo].[sysutility_ucp_volumes] Creating view [dbo].[sysutility_ucp_utility_space_utilization] Creating view [dbo].[sysutility_ucp_instances] Creating view [dbo].[sysutility_ucp_databases] Creating view [dbo].[sysutility_ucp_filegroups] Creating view [dbo].[sysutility_ucp_datafiles] Creating view [dbo].[sysutility_ucp_logfiles] Creating view [dbo].[sysutility_ucp_database_files] Creating view [dbo].[sysutility_ucp_mi_database_file_space_utilizations] Creating view [dbo].[sysutility_ucp_dac_database_file_space_utilizations] Creating view [dbo].[sysutility_ucp_mi_volume_space_utilizations] Creating view [dbo].[sysutility_ucp_dac_volume_space_utilizations] Creating view [dbo].[sysutility_ucp_mi_cpu_utilizations] Creating view [dbo].[sysutility_ucp_computer_cpu_utilizations] Creating view [dbo].[sysutility_ucp_dac_cpu_utilizations] Creating procedure dbo.sp_sysutility_ucp_provision_utility_object_internal Creating function fn_sysutility_ucp_get_aggregated_health Creating view [dbo].[sysutility_ucp_instance_policies]... Creating view [dbo].[sysutility_ucp_computer_policies]... Creating view [dbo].[sysutility_ucp_dac_policies]... Creating view [dbo].[sysutility_ucp_dac_policy_type]... Creating view [dbo].[sysutility_ucp_instance_policy_type]... Creating view dbo.sysutility_ucp_aggregated_dac_health Creating view dbo.sysutility_ucp_aggregated_mi_health Creating view dbo.sysutility_ucp_dac_health Creating view dbo.sysutility_ucp_mi_health Creating procedure dbo.sp_sysutility_ucp_calculate_filegroups_with_policy_violations Creating procedure dbo.sp_sysutility_ucp_calculate_dac_file_space_health Creating procedure dbo.sp_sysutility_ucp_calculate_mi_file_space_health Creating procedure dbo.sp_sysutility_ucp_calculate_computer_health Creating procedure dbo.sp_sysutility_ucp_calculate_dac_health Creating procedure dbo.sp_sysutility_ucp_calculate_aggregated_dac_health Creating procedure dbo.sp_sysutility_ucp_calculate_mi_health Creating procedure dbo.sp_sysutility_ucp_calculate_health Creating procedure dbo.sp_sysutility_ucp_configure_policies Creating [dbo].[sp_sysutility_ucp_remove] procedure Creating procedure [dbo].[sp_sysutility_ucp_remove_mi] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_file_space_health_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_database_health_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_dac_file_space_health_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_volume_space_health_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_file_space_health] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_database_health] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_dac_database_file_space_health] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_volume_space_health] TO [UtilityCMRReader] Dropping extended database property - Microsoft_Management_Utility_Version Creating extended database property - Microsoft_Management_Utility_Version (version '___SQLVERSION___NEW___') Executing: GRANT SELECT ON dbo.[sysutility_mi_configuration_internal] TO [UtilityIMRReader] Executing: GRANT SELECT ON dbo.[sysutility_mi_session_statistics_internal] TO [UtilityIMRReader] Executing: GRANT SELECT ON dbo.[sysutility_mi_dac_execution_statistics_internal] TO [UtilityIMRReader] Executing: GRANT SELECT ON dbo.[sysutility_mi_volumes_stage_internal] TO [UtilityIMRReader] Executing: GRANT SELECT ON dbo.[sysutility_mi_cpu_stage_internal] TO [UtilityIMRReader] Executing: GRANT SELECT ON dbo.[sysutility_mi_smo_stage_internal] TO [UtilityIMRReader] Executing: GRANT SELECT ON dbo.[sysutility_mi_smo_properties_to_collect_internal] TO [UtilityIMRReader] Executing: GRANT SELECT ON dbo.[sysutility_mi_smo_objects_to_collect_internal] TO [UtilityIMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_managed_instances_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_configuration_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_processing_state_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_health_policies_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_aggregated_dac_health_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_aggregated_mi_health_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_dac_health_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_health_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_policy_check_conditions_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_policy_target_conditions_internal] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_deployed_dacs] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_computers] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_volumes] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_utility_space_utilization] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_instances] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_databases] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_filegroups] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_datafiles] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_logfiles] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_database_file_space_utilizations] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_dac_database_file_space_utilizations] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_volume_space_utilizations] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_dac_volume_space_utilizations] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_cpu_utilizations] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[fn_sysutility_ucp_get_file_space_utilization_history] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[fn_sysutility_ucp_get_cpu_utilization_history] TO [UtilityCMRReader] Executing: GRANT EXECUTE ON dbo.[fn_sysutility_get_is_instance_ucp] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_managed_instances] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_configuration] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_policies] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_policy_violations] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_aggregated_dac_health] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_aggregated_mi_health] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_dac_health] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_mi_health] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_policy_check_conditions] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_policy_target_conditions] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_dac_policy_type] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_instance_policy_type] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_instance_policies] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_dac_policies] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[sysutility_ucp_computer_policies] TO [UtilityCMRReader] Executing: GRANT EXECUTE ON dbo.[fn_encode_sqlname_for_powershell] TO [UtilityCMRReader] Executing: GRANT EXECUTE ON dbo.[fn_sysutility_ucp_get_applicable_policy] TO [UtilityCMRReader] Executing: GRANT EXECUTE ON dbo.[fn_sysutility_ucp_get_aggregated_failure_count] TO [UtilityCMRReader] Executing: GRANT EXECUTE ON dbo.[fn_sysutility_ucp_get_global_health_policy] TO [UtilityCMRReader] Executing: GRANT SELECT ON dbo.[fn_sysutility_ucp_get_aggregated_health] TO [UtilityCMRReader] Executing: GRANT EXECUTE ON dbo.[sp_sysutility_mi_collect_dac_execution_statistics_internal] TO [UtilityIMRWriter] Executing: GRANT EXECUTE ON dbo.[sp_sysutility_mi_get_dac_execution_statistics_internal] TO [UtilityIMRWriter] Executing: GRANT SELECT ON dbo.[fn_sysutility_mi_get_batch_manifest] TO [UtilityIMRWriter] Executing: GRANT EXECUTE ON dbo.[fn_sysutility_mi_get_cpu_architecture_name] TO [UtilityIMRReader] Executing: GRANT EXECUTE ON dbo.[fn_sysutility_mi_get_cpu_family_name] TO [UtilityIMRReader] Executing: GRANT EXECUTE ON dbo.[fn_sysutility_get_culture_invariant_conversion_style_internal] TO [UtilityIMRReader] Executing: GRANT SELECT ON dbo.[fn_sysutility_ucp_get_policy_violations] TO [UtilityCMRReader] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_computers] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_computers] FOR [msdb].[dbo].[sysutility_ucp_computers_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_volumes] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_volumes] FOR [msdb].[dbo].[sysutility_ucp_volumes_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_dacs] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_dacs] FOR [msdb].[dbo].[sysutility_ucp_dacs_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_smo_servers] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_smo_servers] FOR [msdb].[dbo].[sysutility_ucp_smo_servers_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_databases] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_databases] FOR [msdb].[dbo].[sysutility_ucp_databases_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_filegroups] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_filegroups] FOR [msdb].[dbo].[sysutility_ucp_filegroups_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_datafiles] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_datafiles] FOR [msdb].[dbo].[sysutility_ucp_datafiles_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_logfiles] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_logfiles] FOR [msdb].[dbo].[sysutility_ucp_logfiles_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_cpu_utilization] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_cpu_utilization] FOR [msdb].[dbo].[sysutility_ucp_cpu_utilization_stub] Executing: DROP SYNONYM [dbo].[syn_sysutility_ucp_space_utilization] Executing: CREATE SYNONYM [dbo].[syn_sysutility_ucp_space_utilization] FOR [msdb].[dbo].[sysutility_ucp_space_utilization_stub] Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install. (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) -------------------------------- Starting execution of Alwayson.SQL -------------------------------- Deleting existing policies, objectsets... Deleting AlwaysOnArJoinStateHealthPolicy Deleting AlwaysOnArJoinStateHealthPolicy_ObjectSet Deleting AlwaysOnAgReplicasConnectionHealthPolicy Deleting AlwaysOnAgReplicasConnectionHealthPolicy_ObjectSet Deleting AlwaysOnAgReplicasDataSynchronizationHealthPolicy Deleting AlwaysOnAgReplicasDataSynchronizationHealthPolicy_ObjectSet Deleting AlwaysOnAgReplicasRoleHealthPolicy Deleting AlwaysOnAgReplicasRoleHealthPolicy_ObjectSet Deleting AlwaysOnAgSynchronousReplicasDataSynchronizationHealthPolicy Deleting AlwaysOnAgSynchronousReplicasDataSynchronizationHealthPolicy_ObjectSet Deleting AlwaysOnDbrJoinStatePolicy Deleting AlwaysOnDbrJoinStatePolicy_ObjectSet Deleting AlwaysOnDbrSuspendStatePolicy Deleting AlwaysOnDbrSuspendStatePolicy_ObjectSet Deleting AlwaysOnAgOnlineStateHealthPolicy Deleting existing AlwaysOnAgOnlineStateHealthPolicy_ObjectSet Deleting AlwaysOnAgAutomaticFailoverHealthPolicy Deleting AlwaysOnAgAutomaticFailoverHealthPolicy_ObjectSet Deleting AlwaysOnArConnectionHealthPolicy Deleting AlwaysOnArConnectionHealthPolicy_ObjectSet Deleting AlwaysOnDbrDataSynchronizationState Deleting AlwaysOnDbrDataSynchronizationState_ObjectSet Deleting AlwaysOnArDataSynchronizationHealthPolicy Deleting AlwaysOnArDataSynchronizationHealthPolicy_ObjectSet Deleting AlwaysOnArRoleHealthPolicy Deleting AlwaysOnArRoleHealthPolicy_ObjectSet Deleting AlwaysOnAgWSFClusterHealthPolicy Deleting AlwaysOnAgWSFClusterHealthPolicy_ObjectSet Creating category: Availability group errors (any replica role)... Creating category: Availability group errors (primary replica only)... Creating category: Availability replica errors... Creating category: Availability database errors... Creating category: Availability group warnings (any replica role)... Creating category: Availability group warnings (primary replica only)... Creating category: Availability replica warnings... Creating category: Availability database warnings... Creating Condition: AlwaysOnAgAutomaticFailoverHealthCondition... Creating Condition: AlwaysOnDbrJoinStateCondition... Creating Condition: AlwaysOnAgWSFClusterHealthCondition... Creating Condition: AlwaysOnArConnectionHealthCondition... Creating Condition: AlwaysOnAgReplicasConnectionHealthCondition... Creating Condition: AlwaysOnAgReplicasDataSynchronizationHealthCondition... Creating Condition: AlwaysOnAgReplicasRoleHealthCondition... Creating Condition: AlwaysOnAgSynchronousReplicasDataSynchronizationHealthCondition... Creating Condition: AlwaysOnDbrSuspendStateCondition... Creating Condition: AlwaysOnDbrDataSynchronizationCondition... Creating Condition: IsHadrEnabled... Creating Condition: AlwaysOnAgOnlineStateHealthCondition... Creating Condition: AlwaysOnArDataSynchronizationHealthCondition... Creating Condition: AlwaysOnArRoleHealthCondition... Creating Condition: AlwaysOnArJoinStateHealthCondition Creating Policy: AlwaysOnAgReplicasConnectionHealthPolicy... Creating Policy: AlwaysOnAgReplicasDataSynchronizationHealthPolicy... Creating Policy: AlwaysOnAgReplicasRoleHealthPolicy... Creating Policy: AlwaysOnAgSynchronousReplicasDataSynchronizationHealthPolicy... Creating Policy: AlwaysOnDbrJoinStatePolicy... Creating Policy: AlwaysOnDbrSuspendStatePolicy... Creating Policy: AlwaysOnAgOnlineStateHealthPolicy... Creating Policy: AlwaysOnAgAutomaticFailoverHealthPolicy... Creating Policy: AlwaysOnArConnectionHealthPolicy... Creating Policy: AlwaysOnDbrDataSynchronizationState... Creating Policy: AlwaysOnArDataSynchronizationHealthPolicy... Creating Policy: AlwaysOnArRoleHealthPolicy... Creating Policy: AlwaysOnAgWSFClusterHealthPolicy... Creating Policy: AlwaysOnArJoinStateHealthPolicy... Creating table [dm_hadr_automatic_seeding_history] Creating procedure sp_delete_dm_hadr_automatic_seeding_history... Creating Managed Backup objects... Adding task agent Microsoft.SqlAutoAdmin.AutoBackupAgent.dll... Creating procedure autoadmin_update_task_agent_path... Creating function fn_autoadmin_schema_version... Creating function fn_autoadmin_min_schema_version... Creating view autoadmin_backup_configurations... Creating view autoadmin_backup_configuration_summary... Creating procedure autoadmin_metadata_query_schema_version... Creating procedure autoadmin_metadata_query_dbs... Creating procedure autoadmin_metadata_insert_task_agent_global_data... Creating procedure autoadmin_metadata_query_task_agent_global_data... Creating procedure autoadmin_metadata_update_task_agent_global_data... Creating procedure autoadmin_metadata_delete_task_agent_global_data... Creating procedure autoadmin_metadata_update_task_agent_data_for_database... Creating procedure autoadmin_metadata_delete_task_agent_data_for_database... Creating procedure autoadmin_metadata_delete... Creating procedure autoadmin_metadata_cleanup... Creating procedure autoadmin_set_system_flag... Creating procedure autoadmin_fetch_system_flags... Creating procedure autoadmin_restore_headeronly... Creating procedure autoadmin_set_master_switch... Creating procedure managed_backup.sp_backup_config_basic... Creating procedure managed_backup.sp_backup_config_advanced... Creating procedure managed_backup.sp_backup_config_schedule... Creating procedure managed_backup.sp_create_job... Creating procedure managed_backup.sp_add_task_command... Creating procedure managed_backup.sp_backup_on_demand... Creating procedure managed_backup.sp_set_parameter... Creating procedure managed_backup.sp_get_backup_diagnostics... Creating procedure managed_backup.sp_backup_master_switch... Creating procedure managed_backup.sp_get_encryption_option... Creating procedure managed_backup.sp_get_striping_option... Creating procedure managed_backup.sp_do_backup... Creating procedure smart_admin.sp_create_job... Creating procedure smart_admin.sp_add_task_command... Creating procedure smart_admin.sp_set_db_backup... Creating procedure smart_admin.sp_backup_on_demand... Creating procedure smart_admin.sp_set_instance_backup... Creating procedure smart_admin.sp_set_parameter... Creating procedure smart_admin.sp_get_backup_diagnostics... Creating procedure smart_admin.sp_backup_master_switch... Creating procedure smart_admin.sp_get_encryption_option... Creating procedure smart_admin.sp_do_backup... Creating function managed_backup.fn_backup_db_config... Creating function managed_backup.fn_backup_instance_config... Creating function managed_backup.fn_is_master_switch_on... Creating function managed_backup.fn_get_parameter... Creating function managed_backup.fn_available_backups... Creating function managed_backup.fn_get_current_xevent_settings... Creating function managed_backup.fn_get_health_status... Creating function smart_admin.fn_backup_db_config... Creating function smart_admin.fn_backup_instance_config... Creating function smart_admin.fn_is_master_switch_on... Creating function smart_admin.fn_get_parameter... Creating function smart_admin.fn_available_backups... Creating function smart_admin.fn_get_current_xevent_settings... Creating function smart_admin.fn_get_health_status... Creating view vw_autoadmin_health_status... Creating procedure sp_check_smartadmin_notification_enabled... Creating procedure sp_autoadmin_notification_job_send_email... Creating procedure sp_autoadmin_create_notification_job... Creating procedure sp_autoadmin_configure_notification... Deleting existing policies, objectsets... Deleting SmartAdminSystemHealthPolicy Deleting SmartAdminSystemHealthPolicy_ObjectSet Deleting SmartAdminUserActionsHealthPolicy Deleting SmartAdminUserActionsHealthPolicy_ObjectSet Creating category: SmartAdmin errors... Creating category: SmartAdmin warnings... Creating Condition: SmartAdminSystemHealthCondition... Creating Policy: SmartAdminSystemHealthPolicy... Creating Condition: SmartAdminUserActionsHealthCondition... Creating Policy: SmartAdminUserActionsHealthPolicy... Completed creating all required Managed Backup objects... ------------------------------------------- Starting execution of MSDB_POST_INSTALL.SQL ------------------------------------------- Msg 468, Level 16, State 9, Line 60981 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Polish_CI_AS" in the equal to operation. Processing sp: [dbo].[sp_sqlagent_is_srvrolemember] Msg 15556, Level 16, State 1, Line 61005 Cannot decrypt or encrypt using the specified certificate, either because it has no private key or because the password provided for the private key is incorrect. Msg 2745, Level 16, State 2, Line 61081 Process ID 56 has raised user error 50000, severity 20. SQL Server is terminating this process. Msg 50000, Level 20, State 127, Line 61081 Cannot sign stored procedure [dbo].[sp_sqlagent_is_srvrolemember]. Terminating. Msg 596, Level 21, State 1, Line 61004 Cannot continue the execution because the session is in the kill state. Msg 0, Level 20, State 0, Line 61004 A severe error occurred on the current command. The results, if any, should be discarded. Completion time: 2024-08-05T10:31:42.8855373+02:00