sp_remove_log_shipping_monitor
SQL Server 2000
Deletes the log shipping monitor information from the log_shipping_monitor table.
Syntax
sp_remove_log_shipping_monitor
Return Code Values
0 (success) or 1 (failure)
Remarks
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.
Permissions
Only members of the sysadmin fixed server role can execute sp_remove_log_shipping_monitor.
Examples
EXEC msdb.dbo.sp_remove_log_shipping_monitor
