How to determine the Instance

Hello:
Would you mind to give me some hints that how can I determine how many
of instance on the SQL server?
Thanks a lot!Hi
Check out
http://www.sqlteam.com/item.asp?ItemID=5403
John
alantang(Anti-Spam) wrote:
> Hello:
> Would you mind to give me some hints that how can I determine how
many
> of instance on the SQL server?
> Thanks a lot!|||The installed instance names are stored in the registry in:
HKLM\Software\Microsoft\Microsoft SQL Server\InstalledInstances.
Alternately, you could write some code to query the SQL Browser service
(which listens on UDP 1434). I don't know for sure but I suspect that
service just reads the above registry value to get the list of installed
SQL instances on the box (plus others to get TCP ports they're listening
on).
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
alantang(Anti-Spam) wrote:

>Hello:
> Would you mind to give me some hints that how can I determine how many
>of instance on the SQL server?
>Thanks a lot!
>

How to determine the Instance

Hello:
Would you mind to give me some hints that how can I determine how many
of instance on the SQL server?
Thanks a lot!
Hi
Check out
http://www.sqlteam.com/item.asp?ItemID=5403
John
alantang(Anti-Spam) wrote:
> Hello:
> Would you mind to give me some hints that how can I determine how
many
> of instance on the SQL server?
> Thanks a lot!
|||The installed instance names are stored in the registry in:
HKLM\Software\Microsoft\Microsoft SQL Server\InstalledInstances.
Alternately, you could write some code to query the SQL Browser service
(which listens on UDP 1434). I don't know for sure but I suspect that
service just reads the above registry value to get the list of installed
SQL instances on the box (plus others to get TCP ports they're listening
on).
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
alantang(Anti-Spam) wrote:

>Hello:
>Would you mind to give me some hints that how can I determine how many
>of instance on the SQL server?
>Thanks a lot!
>