Post reply

How to find Installed Instance Names using SQL query ?

  • January 22, 2009 at 6:52 am

    #126933

    Hi all,

    How to find how many instance is installed in your machine. along with its version....

    Is there any sql command through which i get the installed instance details ....?

    I want inforamtion like

    ServerName (Version) ----> if it is default instance

    ServerName\NamedInstanceName ---->

    Regards

    Shashi Kant Chauhan

  • January 22, 2009 at 7:05 am

    #931134

    try this

    SELECT @@SERVERNAME

  • January 22, 2009 at 7:06 am

    #931137

    I'm sure there are registry entries you could check, but for a quick dirty look at your environment as a whole you could look into SQL Ping http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • January 22, 2009 at 7:14 am

    #931143

    A second vote for SQLPing. Let a domain admin run it for best results. Very useful discovery and auditing tool.

    K. Brian Kelley
    @kbriankelley

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

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