Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: List all databases on all servers

Show all headers | View raw

On Friday, 15 February 2013 07:53:15 UTC, Cathy wrote:
> Had a quick look at apexsql demo, looks nice but still requires me
> to enter all server names. Thing is in a large organisation like ours, 
> others could be deploying sql servers without informing me, 

Can you make your firewall block any SQL Server port that it doesn't
know about, so that they have to ask your permission to have one?

Maybe use the firewall as the source of the current list of 
SQL Server names?

(Then, would they be able to install sneaky extra instances without 
telling you?)

Presumably someone's buying /licences/ for all your SQL Servers, 
so could you get the information from the company accounting 
system?

Or, get hold of one of those viruses that runs amuck on all the 
SQL Servers on a network, and rewrite it to do what you want -
Blaster or Slammer or something.  Of course there's a bit of a 
risk that it harvests the details of every SQL Server on 
planet Earth for you.  Then you can take care of all our backups 
as well...

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | 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