Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  How to get a list of databases from SQL Server 7

Author  Topic  jambrose Starting Member 1 Post Posted - 2001-04-17 : 17:14:50 Is there a way to query SQL Server and get a listing all the databases? I can get a listing of all the tables inside a database by using the INFORMATION_SCHEMA.tables. What I want to accomplish is to provide a web interface (using ASP) to allow the DBA to view all the databases, select a database, and view all the stored procedures in that database. Eventually I'll expand it to list all tables and provide more detail database information. Thanks! Jack