MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Sign in
|
Help
Home
Blogs
Media
Groups
All Tags
»
SQL Server
»
report builder
»
view
(
RSS
)
Browse Site by Tags
Showing related tags and posts accross the entire site.
data sources
reporting services
tsql
TSQL to list all the reports inlcuding data sources on the SQL Server Reporting Server?
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 )
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on 12-27-2007
Filed under: sql server, report builder, view, reporting services, tsql, data sources
Page 1 of 1 (1 items)
Copyright © is the original authors. Blog site is an independent site not sponsored by Microsoft. The Yoda blog server and the Brianna SQL server would like to thank www.ownwebnow.com and www.exchangedefender.com. They wouldn't be here and broadcasting without the generosity of Vlad Mazek and his companies.