Groups > comp.databases.ms-sqlserver > #1390

List all databases on all servers

From	"Cathy" <Cathy@Nospam.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	List all databases on all servers
Date	2013-02-14 21:47 +0000
Message-ID	<heqdnUM4L9nwxoDMnZ2dnUVZ8nadnZ2d@bt.com> (permalink)

Show all headers | View raw

I work in an organisation where we have three Windows Domains

In each domain we have several SQL Servers (mostly 2005 & 2008, but we will 
have 2012 shortly also)

I want to setup a Database and a T-SQL script that queries the network for 
all SQL servers and instances and then puts their names into TBL_SQLSERVERS.

This is to be followed by another query which I already have that uses 
TBL_SQLSERVERS to give me a complete listing of all databases, types of 
backups and data file and log file locations to allow me to check and 
standardise all of these.

Any advice on how to go about getting this done will be appreciated

C

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

List all databases on all servers "Cathy" <Cathy@Nospam.com> - 2013-02-14 21:47 +0000
  Re: List all databases on all servers Erland Sommarskog <esquel@sommarskog.se> - 2013-02-14 23:26 +0100
    Re: List all databases on all servers "Cathy" <Cathy@Nospam.com> - 2013-02-15 07:53 +0000
      Re: List all databases on all servers Erland Sommarskog <esquel@sommarskog.se> - 2013-02-15 10:38 +0100
      Re: List all databases on all servers rja.carnegie@gmail.com - 2013-02-15 03:27 -0800
        Re: List all databases on all servers "Cathy" <Cathy@Nospam.com> - 2013-02-15 15:58 +0000

csiph-web