Solved

A list of SQL Server Databases

Posted on 2004-08-11
2
197 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
Comment Utility

This Sql statement return all databas names on the server:


SELECT Name FROM master..sysdatabases
0
 

Expert Comment

by:DMV
Comment Utility
All right I ran the following:

   SELECT Name FROM master..sysdatabases

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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
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…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

728 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now