Divi WordPress Theme

Get list of databases from SQL Server

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

Offline Chris

  • Junior Guru
  • **
  • Posts: 81
  • 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: 660
  • 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:

command to check Exim mail queue on server

Started by digitalpointBoard cPanel/WHM

Replies: 4
Views: 11761
Last post December 01, 2009, 10:49:16 PM
by kvchosting
Server application unavailable

Started by AnonymousBoard Microsoft IIS

Replies: 1
Views: 5377
Last post March 19, 2007, 08:41:32 AM
by Kailash
commands to start/stop/restart MySQL server

Started by AnonymousBoard MySQL

Replies: 2
Views: 5696
Last post October 11, 2018, 12:51:09 PM
by sankalppatil
Server Error in '/' Application :: Parser Error

Started by MikeBoard .NET Development

Replies: 1
Views: 7619
Last post July 04, 2007, 11:05:24 AM
by Kailash
Redirect the sub-domain on the Linux server (cPanel/WHM)

Started by KailashBoard How Tos

Replies: 0
Views: 10599
Last post July 04, 2007, 11:01:49 AM
by Kailash