Useful Undocumented SQL Server 2016 Stored Procedures (Part 4) SQL Server 2016 supports the following useful undocumented stored procedures: sp_check_log_shipping_monitor_alert sp_create_log_shipping_monitor_account sp_log_shipping_get_date_from_file sp_MSget_jobstate sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs sp_check_log_shipping_monitor_alert The sp_check_log_shipping_monitor_alert log shipping stored procedure is used to check all monitor alerts in the primary database and in the secondary database in log shipping configuration. Syntax sp_check_log_shipping_monitor_alert Return Code Values 0 (success)…
This content is for Pro, Pro Member, Pro Member Annual – Fall Sale, Pro Member Monthly – Fall Sale, Standard, Standard Member, Standard Member Annual – Fall Sale, and Standard Member Monthly – Fall Sale members only.
Register
Register
Already a member? Log in here