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" 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: 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 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