How to select database from a particuler server (mssql server 2005)
Hi,
I want to make a button which browse the all database in a particuler server. How can I do this.
Networks
Hi,
I want to make a button which browse the all database in a particuler server. How can I do this.
by hdeepak Accepted solution
by tony hopkinson Accepted solution
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 Accepted solution
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.
Sort by Trending