Deletes the log shipping monitor information from the log_shipping_monitor table.
Return Code Values
0 (success) or 1 (failure)
This stored procedure removes the monitor from either the primary or secondary server. sp_remove_log_shipping_monitor should be executed after all rows from the log_shipping_databases and log_shipping_plans have been removed. Otherwise, this stored procedure will fail.
Only members of the sysadmin fixed server role can execute sp_remove_log_shipping_monitor.