How do I – Get a list of all databases attached to my SQL Server 2008 R2 database server

Another quick one… You can run this stored procedure:

exec sp_databases

Which should yield the following output:

or you could try this stored procedure:

exec sp_helpdb

Which would yield some more extended information thus:

or if you just want the names, you could execute this “undocumented” stored procedure:

exec sp_msforeachdb 'print ''?'''

Which will yield this:

Or you could do the manual step of executing the following select query:

select name from sys.databases

Which will yield:

Cheers
C