SQL Server Performance

TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Dec 27, 2007.

  1. Anonymous New Member

    Use ReportServer Go SELECT DS . Name as DataSourceName , CT . Name AS ItemName , CT . Path FROM dbo . Catalog CT INNER JOIN dbo . DataSource DS ON CT . ItemID = DS . ItemID Where Type = 2 Order by DataSourceName , ItemName...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/12/27/3028.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3028" width="1" height="1">

Share This Page