Browse by Tags

All Tags » data sources   (RSS)
TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?
27 December 07 05:35 AM | SQL Master | 2 Comments   
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 Read More...