Home Forums SQL Server 2005 Administering How to find out Installed SQL Server Instances on a server RE: How to find out Installed SQL Server Instances on a server

  • September 14, 2011 at 10:39 pm

    #1381719

    crazy4sql (9/14/2011)

    Raghavender (9/13/2011)

    Hi All,

    How to find out Installed SQL Server Instances and their names on a server using T-SQL or any other way ?

    The easiest way for me is, go to services and check the sql server services.

    If its named instance then your sql service will be named as mssql$instancename, if its default instance then simply mssqlserver.

    I think this becomes bit difficult if we have 100 instances or more 🙂 ..

    Thank You,

    Best Regards,

    SQLBuddy