http://www.codeproject.com/cs/database/SubmitSQLInfoEnumerator.asp
This should answer all your questions, if not let us know
Chris Farrell
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
Dean Fiala
Sent: Friday, April 21, 2006 3:03 PM
To: [email protected]
Subject: [Spam] Re: [AspNet2] Finding list of sql servers
You might want to check the code project for a more polished tool, but
the list of databases is available from a SQL Server instance via
system stored proc:
sp_databases
You can just create a command to call it like any other stored proc
and load the results into a dropdown list. The permissions are set to
public, so credentials won't be a problem.
Not sure about a list of servers. They will have to have been
registered by the client PC in some way. First try would be searching
the registry, but if the client doesn't have VS or any SQL tool
installed you probably won't find anything unless they have DNS
entries created by another application. Theoretically you could search
the network for instances (like the slammer worm), but that might be
overkill.
On 4/21/06, Sharon <[EMAIL PROTECTED]> wrote:
> I am trying to create a UI like the one in VS.Net where you create a
database connection. A drop down with the list of sql servers, a dropdown
with list of databases in the selected server. My problem is how can I get
these information. or is there a way where i can use the one in vs.net. I
need this to ship with the application.
>
> All help is great help.
>
> Thanks
> Sharon
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
Now with Blogging...
http://www.vpsw.com/blogbaby
Microsoft MVP
_____
YAHOO! GROUPS LINKS
* Visit your group "AspNet2 <http://groups.yahoo.com/group/AspNet2> "
on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
YAHOO! GROUPS LINKS
- Visit your group "AspNet2" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
