Line count on reports? RRS feed

  • Question

  • I have a query that returns to me all the PROC's, tables and SSRS reports on a server. For the PROC's and tables I am able to get a line/row count so I can compare version between the enviroments. I would like to get line count of code for the SSRS report list as well but I suspect that information is not stored in SQL Server.

    If not, any other method of compare suggested?

    Thanks so much for the help.

    Thursday, April 26, 2012 3:26 PM


  • answer:

    LEN(CONVERT(varbinary(max), content) from reportserver.dbo.catalog

    • Marked as answer by Mike Yin Monday, April 30, 2012 8:19 AM
    Thursday, April 26, 2012 5:08 PM