Divi WordPress Theme

Topic: Get list of databases from SQL Server  (Read 290 times)

Offline Chris

  • Junior Guru
  • **
  • Posts: 77
  • iTrader: +0/-0
    • View Profile
Get list of databases from SQL Server
« on: October 30, 2019, 04:54:01 PM »
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?
VPS Hosting - AccuWebHosting

Offline Kailash

  • Web Hosting Master
  • *****
  • Administrator
  • Posts: 652
  • iTrader: +153/-0
    • View Profile
Re: Get list of databases from SQL Server
« Reply #1 on: October 30, 2019, 04:54:31 PM »

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.
Shopify Divi WordPress Theme
Tags: