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
Post a Comment