Doubt about SQL Server

[aguzmanc@gmail.com]

I need an application to obtain the databases names from my SQL
Server, using Visual Basic 6.0.
Can somebody hel me?

[Erland Sommarskog]

Re: Doubt about SQL Server

(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..sysdata bases -- SQL 2000 or earlier
SELECT name FROM sys.databases -- SQL 2005.

Or what is you want help with?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.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