SQL: Get list of all user databases

If you want to omit system databases, DQS, ReportServer (if installed) :

 

select name from sys.databases
where name not in (‘master’, ‘model’, ‘msdb’, ‘tempdb’)
and name not like ‘%DQS%’
and name not like ‘%Report%’
order by name

Advertisements

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