sql server - SSRS - "Content" field doesn't update for data source when connection string is updated? -


i'm building ssrs audit checks "content" field in reporting database's catalog table. i've noticed when data source's connection string updated different server or db after being deployed, content field in database continue showing old connection string - however, other fields such name or path update immediately. haven't been able find online - has experienced similar?

my environment ssrs 2012 & sql server 2012.

the query i'm using read content is:

select      convert(varchar(max), convert(varbinary(max), substring(convert(varbinary(max), content), 4, len(convert(varbinary(max), content))))) content catalog type = 5 


Comments

Popular posts from this blog

mysql - Dreamhost PyCharm Django Python 3 Launching a Site -

java - Sending SMS with SMSLib and Web Services -

java - How to resolve The method toString() in the type Object is not applicable for the arguments (InputStream) -