Infographic Mentalist > Image worth explaining thousand Words SQL Server Mentalist > SQL Learning Blogīusiness Intelligence Mentalist > BI World If you want daily link and analysis or interesting link go to following website which will give your inbox please subscribe our following link resource blog :įor More information related to BI World visit my Mentalist Blog If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.
Hope you will like How to List connection strings of all SSRS Shared Data sources. SharedDsName SQL Script Output Screenshot WHERE CON.ConnString LIKE '%Initial Catalog%=%TFS%' nodes ( '/DataSourceDefinition' ) AS R (DSN value ( 'ConnectString', 'varchar(150)' ) ASĬROSS APPLY SDS. , CONVERT ( XML, CONVERT ( VARBINARY ( max ), content )) AS DEF XML namespace def must be the first in with clause. SQL Script Output Columnĭirectly execute the script on Report Server Database.
With this Transact-SQL query for ReportServer database you get the connection string of all Shared Datasources, to document the usage or to search for a specific server/database. Let’s say you want to move a database to an other SQL Server, but which of the SSRS Shared Datasources uses this database and must be changed afterwards? How to find List of connection strings of all SSRS Shared Data sources? Description of SQL Script: In this post we are going to discuss following points: In this article we are going to cover How to List connection strings of all SSRS Shared Data sources.