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

Recommended Providers



WordPress Hosting

Jetpack
Fully Managed WordPress Hosting
lc_banner_leadgen_3
Fully Managed WordPress Hosting

WordPress

WordPress Hosting Divi WordPress Theme
WPZOOM
Bluehost WordPress Hosting

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.


WordPress Hosting