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!|||This is a multi-part message in MIME format.
--020806090001060209080708
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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!
>
--020806090001060209080708
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>The installed instance names are stored in the registry in:<br>
HKLM\Software\Microsoft\Microsoft SQL Server\InstalledInstances.<br>
<br>
</tt><tt>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).</tt><br>
<tt><font size="2"></font></tt>
<div class="moz-signature">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
alantang(Anti-Spam) wrote:
<blockquote cite="midefVH9iWGFHA.3492@.TK2MSFTNGP12.phx.gbl" type="cite">
<pre wrap="">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!
</pre>
</blockquote>
</body>
</html>
--020806090001060209080708--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment