List multiple properties from multiple database

• Footage

  SSC Enthusiast

  Points: 183

  More actions

  June 24, 2020 at 12:10 am

  #3764858

  I am trying to generate a list of multiple properties from multiple databases (looking for the same properties in all). I have been trying to use DATABASEPROPERTYEX, but it is very limited on which properties I can get values for, and some of the properties it does allow are returning NULL.

  I'm getting values for name, version, useraccess, isautoshrink, recovery and status. Size, owner, SpaceAvailable, MaxSizeInBytes all return NULL. Is there better way?

  Cheers

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  June 25, 2020 at 1:10 am

  #3765009

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• February 22, 2021 at 4:07 pm

  This was removed by the editor as SPAM