Home Forums SQL Server 2005 Administering How can"Transaction Log Shipping status" report on Management Studio be subscribed to mailIDs. RE: How can"Transaction Log Shipping status" report on Management Studio be subscribed to mailIDs.

  • Well, I thought this would be a bit easier than it probably will be. The report file itself must be embedded in the actual application as I couldn't find it on the drive in what I would consider to be the standard locations. Based on Books Online it calls sp_help_logshipping_monitor stored procedure so, you should be able to use that to quickly develop a report in reporting services so that you can send it out via email daily as you are required.

    I don't know of any way to schedule the standard reports for distribution outside of getting them in reporting services.

    Hope this helps.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot