RE: How to find available SQL Server on local network
- From: "Job Lot" <JobLot@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 30 Apr 2005 22:04:08 -0700
Doesn't it show instances installed on local machine?
"Jakob Christensen" wrote:
> You can do this using SQL-DMO. Add a reference to sqldmo.dll and sqldmo.rll
> to use SQL-DMO. The Application object of SQL-DMO has a ListAvailableServers
> method which will give you all SQL Servers on the network (if you are running
> Windows 2000 and up).
>
> You can also connect to an SQL Server instance and enumerate all objects for
> that server (using the SqlServer object).
>
> Links:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;287737
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con03_8q44.asp
>
> Of course, the code will be a bit different in VB.net.
>
> HTH, Jakob.
>
>
>
> "Job Lot" wrote:
>
> > Using VB.NET how can I find all available SQL Server on a local network and
> > list all the databases in each server.
> >
> > Thanks
.
- Prev by Date: Re: ADO DB Connection (SQL Server) via ASP.Net web app - help!!!!
- Next by Date: Setting the current value in a DropDownList
- Previous by thread: Re: Debbuging in VS.NET
- Next by thread: RE: How to find available SQL Server on local network
- Index(es):
Relevant Pages
|
