Server Name in Registry

[al]

Greetings,

Under which Registry key can I find SQL Server Name?

MTIA,
Grawsha

[Simon Hayes]

"al" <gr*********@yahoo.com> wrote in message
news:66**************************@posting.google.c om...

Greetings,

Under which Registry key can I find SQL Server Name?

MTIA,
Grawsha

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_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\InstalledInstances

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

Simon