Solved

A list of SQL Server Databases

Posted on 2004-08-11
2
211 Views
Last Modified: 2010-05-02
Hello
I have a DECommand that connects to SQL Server.
I would like to know how I can get a list of databases in that SQL Server at trhe run-time.
Thanks.
0
Comment
Question by:v_shalchian
2 Comments
 
LVL 8

Accepted Solution

by:
SNilsson earned 125 total points
ID: 11780929

This Sql statement return all databas names on the server:


SELECT Name FROM master..sysdatabases
0
 

Expert Comment

by:DMV
ID: 15152510
All right I ran the following:

   SELECT Name FROM master..sysdatabases

and received 8 database rows, one of which is blank.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question