Here is a handy script to list all the Shared Data Sources from the ReportServer Database.
WITH BasicData AS ( SELECT CONVERT(VARBINARY(MAX),Content) AS Content, [Catalog].Name,[Path],ConnectionString FROM [Catalog] INNER JOIN DataSource ON [Catalog].ItemID=DataSource.ItemID WHERE [Type]=5 -- Type=5, Filters Shared Data Sources ) ,DataWithXML AS ( SELECT Name, [Path], CONVERT(XML,Content) AS ContentXML FROM BasicData ) SELECT Name, [Path], ConnectionString.value('(text())[1]','nvarchar(max)') AS ConnectionString FROM DataWithXML CROSS APPLY DataWithXML.ContentXML.nodes('//*:ConnectString') AS ConnectionStrings(ConnectionString)
8 comments:
Truly a very good article on how to handle the future technology. After reading your post,thanks for taking the time to discuss this, I feel happy about and I love learning more about this topic.
SEO Company in Chennai
It is really a great and useful piece of info. I’m glad that you shared this helpful info with us. Please keep us informed like this. Thank you for sharing.
J2ee Training in Chennai Adyar
Thanks you for sharing the unique content. you have done a great job. thank you for sharing such a unique content.
Informatica Training in Chennai Adyar
Hi author, great share. I've just started learning to code and this particular post might come handy in the future. For that i am following your site regularly. Best of regards from EvoEssay.com hope you could visit us too when you're free.
I have read your blog its very attractive and impressive. I like it your blog.
SEO Services in India SEO Company in India SEO Company in India
Guaranteed SEO services Guaranteed SEO
Nice and good article.. it is very useful for me to learn and understand easily.. thanks for sharing your valuable information and time.. please keep updating.
Java Training in chennai
Java Training institute in chennai
Good one, very informative.. thanks for sharing your views and ideas.. it is very useful to me.. thanks once again
Software Testing Training in chennai | Android Training in chennai
Great Article
IEEE Final Year Projects for CSE Final Year Project Centers in Chennai
Post a Comment