Post reply

Querying Configurations

  • July 2, 2020 at 12:00 am

    #3763164

    Comments posted to this topic are about the item Querying Configurations

  • July 2, 2020 at 12:19 am

    #3766897

    sys.configurations is not a DMV. It's a system view. DMV should start with "dm_" prefix.

  • July 2, 2020 at 5:18 am

    #3766919

    Interesting...

    Thanks for the question, Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • July 2, 2020 at 5:21 am

    #3766920

    ilyaioffe wrote:

    sys.configurations is not a DMV. It's a system view. DMV should start with "dm_" prefix.

    well the question does state:

    I can query various instance setting with sp_configure, but can I get these same settings in a DMV or system view?

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

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

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