Posted by Erland Sommarskog on 02/02/07 23:10

(aguzmanc@gmail.com) writes:
> I need an application to obtain the databases names from my SQL
> Server, using Visual Basic 6.0.
> Can somebody hel me?

SELECT name FROM master..sysdatabases -- SQL 2000 or earlier
SELECT name FROM sys.databases -- SQL 2005.

Or what is you want help with?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]