Re: Get all sql servers on network from dot net app.. sqldmo or reflection
From: Benny Tordrup (nospam)
Date: 06/24/04
- Previous message: Vishal Parkar: "Re: ExecIsTriggerDisabled OBJECTPROPERTY"
- In reply to: Martin: "Get all sql servers on network from dot net app.. sqldmo or reflection"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Jun 2004 10:12:21 +0200
Hi,
At home, I have code to retrieve a list of SQL Servers (including named
instances of SQL 2000). This code uses the libraries from MDAC, which are
installed with newer versions of Windows or can be downloaded at Microsoft.
I'll find the code and post it later today.
Best regards,
Benny Tordrup
"Martin" <martin@hotmail.com> skrev i en meddelelse
news:O42LWabWEHA.644@tk2msftngp13.phx.gbl...
> Hi,
>
> I am writing a desktop .net app (vb.net) and part of that app is to
display
> a dropdown list of all sql servers on the network.
>
> I have managed to accomplish that using the sql dmo library, however I am
> aware that the sql dmo library is being depreciated by microsoft,
>
> so my question is would it be better to get a list of all servers of the
> network using the reflection namespace and if so can anybody point me in
the
> direction of how to do this, or can I get a list by querying one of the
> system databases from within sql server itself.
>
> any help is appreciated.
>
> cheers
>
> martin.
>
>
>
- Previous message: Vishal Parkar: "Re: ExecIsTriggerDisabled OBJECTPROPERTY"
- In reply to: Martin: "Get all sql servers on network from dot net app.. sqldmo or reflection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
