May 19, 2015 at 7:54 am
Hi,
Just want to know Is there any way we can find number of reports depend on one Stored procedure?
May 19, 2015 at 8:54 am
implied dependancies only, i'm afraid.
you can search the ReportServer.dbo.catalog for specific strings; and ideally int eh <CommandText> of the xml itself, sicne that's the command that the datasource sues.
this is what i just put together:
WITH MyCTE
AS
(
select convert(varchar(max),CONVERT(varbinary(max),Content))As StrContent,*
from reportserver.dbo.Catalog
)
SELECT SUBSTRING(StrContent,p1.i,p2.i - p1.i) As MostOfCommandText,* FROM MyCTE
CROSS APPLY(SELECT CHARINDEX('<CommandText>',StrContent) As i) p1
CROSS APPLY(SELECT CHARINDEX('</CommandText>',StrContent) As i) p2
WHERE SUBSTRING(StrContent,p1.i,p2.i - p1.i) LIKE '%MyProcedureName%'
Lowell
May 19, 2015 at 8:55 am
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy