Server Name in Registry

[al]

Greetings,

Under which Registry key can I find SQL Server Name?

MTIA,
Grawsha

[Simon Hayes]

Re: Server Name in Registry


"al" <grawsha2000@ya hoo.com> wrote in message
news:66edfd3c.0 311280926.4bd96 fa2@posting.goo gle.com...[color=blue]
> Greetings,
>
> Under which Registry key can I find SQL Server Name?
>
> MTIA,
> Grawsha[/color]

You need to clarify what you mean by the server name. Do you mean the
hostname of the server, or the name of a specific MSSQL instance on the
server? If the first, then it would be better to use an interface like WMI
to get the name. If the second, then you can look at this key:

HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\Microso ft SQL
Server\Installe dInstances

From TSQL, you can use serverproperty( ) to get this information.

Simon