Hi there,

Does anybody know of a way to find out where sqlserver.exe resides on any
given sql server installtion. I am looking for a programatic way to find out
where the binn folder is.
Thanks!

Hello Rex,

You may want to try to get the Binn folder's path from the Regedit?

For example you can find the path from the following key in Registry Editor:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

You can also find the SQL Server instance's name, version info, edition info
and other useful informatin in that node.

Here's the name of the SQL Server instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1

--
Ekrem Önsoy



"Rex Gibson" <noamt1@gmail.com> wrote in message
news:OKOWMkesIHA.1240@TK2MSFTNGP02.phx.gbl...
> Hi there,
>
> Does anybody know of a way to find out where sqlserver.exe resides on any
> given sql server installtion. I am looking for a programatic way to find
> out where the binn folder is.
> Thanks!
>