Querying Configurations

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738171

  More actions

  July 2, 2020 at 12:00 am

  #3763164

  Comments posted to this topic are about the item Querying Configurations

• ilyaioffe

  SSCrazy

  Points: 2456

  More actions

  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.

• Stewart "Arturius" Campbell

  SSC Guru

  Points: 72725

  More actions

  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”

• Stewart "Arturius" Campbell

  SSC Guru

  Points: 72725

  More actions

  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”