Question Locked

How to select database from a particuler server (mssql server 2005)

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I want to make a button which browse the all database in a particuler server. How can I do this.

3 replies

by tony hopkinson

MS SQL they are in the system table sysdatabases, there will be an sp_help... as well.
MySQL it's show databases

Once you've got the drop them in a list or combo box. Presumably the user doing the showing has the relevant permissions.

by p.j.hutchison

To get a list of databases use:

use master
select name from sysdatabases;

Then your web page can use the information to populate a drop down list populated by the database names using ASP, PHP or Perl to create the web page.

This discussion is closed to new replies.