Hi friends, How can we Query to Report Server and Check the Status of that , is it still Running or Locked Out ? Can we write query to access the property of Report Server and it's Status in SSMS ? Thanks.

Hmm, perhaps some info can ve found here SELECT * FROM dbo.ExecutionLogBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hmm, perhaps some info can ve found here SELECT * FROM dbo.ExecutionLogBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Thanks for the Relying me. Can you please describe me in more detail ? Thanks.

Thanks for the Relying me. Can you please describe me in more detail ? Thanks.

Uri's query provides useful information if you run this query against the report server database within SSMS. The default name of this database is "ReportServer". The following link provides other very useful information about report execution; - http://www.purplefrogsystems.com/blog/2008/05/ssrs-report-performance-monitoring/ If you have found any of my posts helpful then please vote them as helpful. Kieran Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds

Uri's query provides useful information if you run this query against the report server database within SSMS. The default name of this database is "ReportServer". The following link provides other very useful information about report execution; - http://www.purplefrogsystems.com/blog/2008/05/ssrs-report-performance-monitoring/ If you have found any of my posts helpful then please vote them as helpful. Kieran Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds

Uri's query provides useful information if you run this query against the report server database within SSMS. The default name of this database is "ReportServer". The following link provides other very useful information about report execution; - http://www.purplefrogsystems.com/blog/2008/05/ssrs-report-performance-monitoring/ If you have found any of my posts helpful then please vote them as helpful. Kieran Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds

Status of report server is not store in SSMS, so we might not be able to get it using the Query in SSMS.Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Status of report server is not store in SSMS, so we might not be able to get it using the Query in SSMS.Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.