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

List all databases on all servers

Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!feeder.erje.net!eu.feeder.erje.net!border3.nntp.ams.giganews.com!Xl.tags.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!local2.nntp.ams.giganews.com!nntp.bt.com!news.bt.com.POSTED!not-for-mail
NNTP-Posting-Date	Thu, 14 Feb 2013 15:47:25 -0600
From	"Cathy" <Cathy@Nospam.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	List all databases on all servers
Date	Thu, 14 Feb 2013 21:47:23 -0000
MIME-Version	1.0
Content-Type	text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding	7bit
X-Priority	3
X-MSMail-Priority	Normal
X-Newsreader	Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE	Produced By Microsoft MimeOLE V6.0.6002.18463
Message-ID	<heqdnUM4L9nwxoDMnZ2dnUVZ8nadnZ2d@bt.com> (permalink)
Lines	17
X-Usenet-Provider	http://www.giganews.com
X-AuthenticatedUsername	NoAuthUser
X-Trace	sv3-Mzv6U3Kc/XtvLtSSjK/UT4Uk3YDxIKKZhdrpMXNjI8IcdAQY82wTSP1gOuFQhNkks+Ebd54zxBcVhjp!dRAHvV3yKc7PNk+mwZJFl4t2OLhAf51klKYEQjD+vrRiX9Z6gcZMkfmEPv6CeOCA26zKil3KJoA=
X-Complaints-To	abuse@btinternet.com
X-DMCA-Complaints-To	abuse@btinternet.com
X-Abuse-and-DMCA-Info	Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info	Otherwise we will be unable to process your complaint properly
X-Postfilter	1.3.40
X-Original-Bytes	1819
Xref	csiph.com comp.databases.ms-sqlserver:1390

Show key headers only | 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