Browse by Tags

All Tags » tsql » reporting services » view (RSS)
TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?
Published 27 December 7 6:35 AM | SSQA.net
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 ) Read More.....
Filed under: , , , , ,