August 28, 2013 at 8:31 am
Hi,
I am using SQL Server 2008 R2 and would like to access the Transaction Log Shipping Status report using TSQL.
To access this report using SSMS you right click on the SQL Server instance and then go to Reports > Standard Reports and Transaction Log Shipping Status report.
I want to be able to access the Transaction Log status report data using TSQL.
This data is stored in a table somewhere in SQL Server but I'm not sure where.
Specifically I need access to all the columns in this report.
Any help most appreciated.
August 29, 2013 at 6:24 am
Although I cant provide you with the code, the easiest way would be to trace your server whilst running the report and you will be able to capture the code being ran.
MCITP SQL 2005, MCSA SQL 2012
August 29, 2013 at 7:02 am
The information for that report comes from here:
sp_help_log_shipping_monitor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply