ac3ab911_or_Log_Shipping__Transact_SQL___Run_this_procedure_on
[Stored procedure] sp_help_log_shipping_secondary_database [Description] Retrieves secondary-database settings from the log_shipping_secondary, log_shipping_secondary_databases and log_shipping_monitor_secondary tables. [Run this procedure on] 
Secondary server
Monitor Log Shipping (Transact-SQL)