• Welcome to Web Hosting Community Forum for Webmasters - Web hosting Forum.
 

Recommended Providers

Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress Theme

Divi WordPress Theme
WPZOOM

Forum Membership

Forum Membership

Get list of databases from SQL Server

Started by Chris, October 30, 2019, 04:54:01 PM

Chris

I have few SQL servers and I would like to export the database name list from each Microsoft SQL server. What is the easy way to get list of all databases from SQL server?

Kailash


The best way to get list is as follow:

SELECT name
FROM master.dbo.sysdatabases


Once you get list, you can copy it. You may exclude default system databases like master, model, msdb ,testdb.