Post reply

List of all the instances installed on one machine.

  • December 31, 2009 at 5:00 am

    #143858

    Hello,

    I need to list out all the instances installed on one machine irrespective of the groups they are categorized under. I want to get the list using T-SQL only (not VB or C# etc...)

    It is urgent. Thanks in advance.

    Rgds,
    Pankaj

  • December 31, 2009 at 6:49 am

    #1097858

    Command prompt:

    isql -L

    Store that in SQL column. Google for ISQL, OSQL to find out more options.

  • December 31, 2009 at 6:52 am

    #1097861

    Just to add...

    Ideally, you would want to store the list of all instances/databases in a centralised place. Once you have this sort of documentation in place, many of the maintenance processes may be automated.

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

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