Caveman's Blog

My commitment to learning.

Sql Server: How to list all the database names

leave a comment »


There are two ways of listing the available database names in SQL Server, using T-SQL


select name from master..sysdatabases

EXEC sp_msForEachDB 'PRINT ''?''';

Advertisements

Written by cavemansblog

November 6, 2009 at 4:51 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: