Post reply

How many instances and what are their names and versions

  • July 29, 2009 at 3:15 am

    #136820

    Hi

    Is there a quick query that will show me how many instances of SQL server are installed on my laptop and what version they are (2000, 2005 etc) and what their names are?

    Thanks

  • July 29, 2009 at 5:50 am

    #1031563

    select @@VERSION

    this will tell you what version is running on your machine

    to check versions

    click on

    connect --> goto "browser for more" from servername -- > on local server you will get all running instances.

  • July 29, 2009 at 8:49 am

    #1031762

    You could look in Admin Tools-->Services and see what SQL Server Services are installed.

    Or in the registry in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server, there's a key 'Installed Instances'

  • July 29, 2009 at 9:34 am

    #1031806

    Thanks Both

  • July 29, 2009 at 2:26 pm

    #1032020

    Run the SQL Server Configuration Manager - this will show you all the SQL related services running on the machine.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 5 posts - 1 through 4 (of 4 total)

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