Re: List availalbe SQL Servers?

Jouni Aro <jouni.aro@xxxxxxxxx> wrote in
news:47eb5a02$1@xxxxxxxxxxxxxxxxxxxxxx:

Chris.Cheney wrote:
Jouni Aro <jouni.aro@xxxxxxxxx> wrote in
news:47ea39b3@xxxxxxxxxxxxxxxxxxxxxx:

FWIW I have run that code on a computer where there is a default
instance of SQL Server 2000 and a (network-disabled) named instance
of SQL 2005 Express, and it only finds the SQL Server 2000 instance,
whereas SQL Service Manager finds both.

Did you refer to Vitali's code or the SMO here?

Sorry for the confusion, I meant Vitali's code.

However, it is the answer to what you can do when SQL DMO is not
supported.

I suppose you mean both the OLEDB/SQLNCLI Enumerator or SMO here?

Sorry again for the confusion, I again meant using Vitali's code.

.

Relevant Pages

  • Re: Creating Primary key with ODBC
    ... > (Sorry for line confusion, ... Have you checked which version of the ODBC SQL Server driver you have? ...
    (comp.databases.ms-sqlserver)
  • SQL Server Licensing
    ... I have a small confusion in the way the licensing of SQL Server works. ... have a per processor license for my SQL Server 2000. ... Rest assured I will not be a bug on the phone.. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Profiler Automated
    ... determine if the database servers have SQL Server 2005 Profiler set to ... Ehum, I may be in a state of confusion, but I don't really know what ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Using SMO for SQL Server 2008 Express AND SQL Server 2005 Expr
    ... InstallShield bundles our SMO references into our installer. ... we see SMO v9.00.3042.00 libraries have been copied ... work with SQL Server 2005, ... little hack to copy this dll as well. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using SMO for SQL Server 2008 Express AND SQL Server 2005 Expr
    ... InstallShield bundles our SMO references into our installer. ... we see SMO v9.00.3042.00 libraries have been copied ... work with SQL Server 2005, ... little hack to copy this dll as well. ...
    (microsoft.public.dotnet.framework.adonet)