Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: SQL server 2008 Build List

    The build list for SQL 2008 has a problem. The top 3 entries for it are incorrect:

    10.00.5829 2799883 Cumulative update package 9 for SQL Server 2008 Service Pack 3 Three...

  • RE: Report Server Diagnostic Reports

    Another fun XML query. This one will get the command text for Datasets in the report:

    Create a Query to Get the Report Datasets Using the GetReportDefintion Method

    • Right click on the...

  • RE: Report Server Diagnostic Reports

    michael_davis2 (1/12/2012)


    Awesome stuff James!!!

    This is a really great find and is in many ways a holy-grail find for what we've been trying to do!!!

    Thanks! FYI, I've updated the prior post...

  • RE: Report Server Diagnostic Reports

    Hi Mike,

    I've done some further tinkering (trying to find a way to get those Data Sources) and figured out something really cool! You can access the Reporting Service Web Services...

  • RE: SQL Server 2008 Build List

    Jay Milo (7/25/2011)


    we are running a build that I do not see on your list - now I've got to ask our Sys admin to get us up to SP1!

    Microsoft...

  • RE: Report Server Diagnostic Reports

    michael_davis2 (11/9/2010)


    thanks jcoe - i'll have to take a look at the data source as that is something in particular we're looking to include. the problem we have encountered...

  • RE: SQL server 2008 Build List

    matthew.stone (4/1/2011)


    Thank you, that does provide a good bit of information. I thought a spot on the 2008 build list would show at what point R2 was started. ...

  • RE: SQL server 2008 Build List

    You need to look here if you want the build list for 2008 R2: http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/[/url]

  • RE: Report Server Diagnostic Reports

    Hi Mike,

    I've also come up with a slight restatement of my prior query that allows the datasource that the query runs against to be identified as well:

    ;WITH ReportItems (ItemID, Name,...

  • RE: Report Server Diagnostic Reports

    Hi Mike,

    I was modifying the reports to provide data to one of our users on only specific reports. While I was going through the queries, it occurred to me that...

  • RE: Report Server Diagnostic Reports

    Try using this as a substitute for the query in ReportQueries.rdl to retrieve SQL queries from reports.

    ;WITH ReportItems (ItemID, Name, Path, reportXml) AS

    (

    ...

  • Viewing 12 posts - 1 through 12 (of 12 total)