Hello,
We are discovering MS SQL Databases from the MSSQL DB on Windows pattern. I need to pull data from the sys.extended_properties of each DB.
select major_id, name, value
from sys.extended_properties
where name = 'XXX'
Has anyone managed to do this or suggest how / what step? I see the databases are created in the 'create db connections' section of the pattern.
Any help is appreciated.
