Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Browse through list of databases on SQL server

RFicklingRFickling Member Posts: 14
Hi,

I would like to allow users of my ADO.NET application to browse through a list of the available databases on a given SQL server. INFORMATION_SCHEMA in SQL Server Books Online doesn't describe how to do this. How can I do this?

TIA,
Royce

Comments

  • BaldusariusBaldusarius Member Posts: 162
    For SQL Server 2000, that information is contained in the sysdatabases table, which is in the Master database. The structure of that table is in BOL.

    : Hi,
    :
    : I would like to allow users of my ADO.NET application to browse through a list of the available databases on a given SQL server. INFORMATION_SCHEMA in SQL Server Books Online doesn't describe how to do this. How can I do this?
    :
    : TIA,
    : Royce
    :
    :

Sign In or Register to comment.