Post reply

Can T-SQL be used for reporting on Surface Area Configuration properties for Analysis Service and Reporting Services?

  • August 10, 2010 at 8:23 am

    #225273

    My requirement is to have an automated way of figuring out the settings of configuration properties for Analysis Service and Reporting Services.

    Can T-SQL be used for reporting on Surface Area Configuration properties for Analysis Service and Reporting Services?

    Or the configuration files are the only place that I could look into?

    Please help!

    Damodar Shanke

    If U need things 2 b done,
    then do the things that U need to be doing! :cool:

  • August 10, 2010 at 9:11 am

    #1204857

    I believe that Surface Area Configuration settings are stored in the Windows registry, or, may be some in config files but not in the Database.

    Theoretically speaking you can use T-SQL to read and display them. However, you will need to create some executable or COM object which you will execute from T-SQL. Do you really want to do so...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • August 11, 2010 at 1:21 am

    #1205179

    Thanks Eugene. I guess I will stick to look at the configuration files which are in xml format! 🙂

    Thanks,

    Damodar Shanke

    If U need things 2 b done,
    then do the things that U need to be doing! :cool:

  • August 11, 2010 at 2:44 am

    #1205208

    You can upload XML files and analyse them using T-SQL

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply