Post reply

How to query Extended Properties from multiple servers

  • March 29, 2011 at 5:36 am

    #100757

    I have many SQL Server servers running in our shop. I have populated all the databases with Extended Property information. Is there a way to query all the servers from one script to get all or parts of the Extended Properties information?

    Thanks!

    Charlie

  • March 29, 2011 at 1:12 pm

    #1305106

    Here's a script to query the data per SQL instance:

    EXECUTE sp_msforeachdb 'USE ? SELECT DB_NAME(); SELECT *

    FROM sys.extended_properties'


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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