List Database names on server

[R7Dave]

Hello

Is there a way to use T-SQL to return a list of databases on a server for SQL2005?

Something like

Select * from INFORMATION_SCHEMA.???

or

select name from sysobjects where ...

is there a method that will return a list of databases?

Thanks
Dave

 

[SQLDenis]

select name from sys.sysdatabases

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server Programming Hacks

 

[R7Dave]

Awesome - Thank You!