Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1394
| X-Received | by 10.224.208.9 with SMTP id ga9mr2451748qab.8.1360927638770; Fri, 15 Feb 2013 03:27:18 -0800 (PST) |
|---|---|
| X-Received | by 10.49.15.100 with SMTP id w4mr59199qec.26.1360927638749; Fri, 15 Feb 2013 03:27:18 -0800 (PST) |
| Path | csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!t2no1397686qal.0!news-out.google.com!k2ni33058qap.0!nntp.google.com!t1no1411516qaz.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | comp.databases.ms-sqlserver |
| Date | Fri, 15 Feb 2013 03:27:18 -0800 (PST) |
| In-Reply-To | <UdWdnW3cqsDxdIDMnZ2dnUVZ8kudnZ2d@bt.com> |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=194.83.173.135; posting-account=dELd-gkAAABehNzDMBP4sfQElk2tFztP |
| NNTP-Posting-Host | 194.83.173.135 |
| References | <heqdnUM4L9nwxoDMnZ2dnUVZ8nadnZ2d@bt.com> <XnsA167EE7289BA2Yazorman@127.0.0.1> <UdWdnW3cqsDxdIDMnZ2dnUVZ8kudnZ2d@bt.com> |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <d5270923-17fe-4860-b046-dee16383ae2b@googlegroups.com> (permalink) |
| Subject | Re: List all databases on all servers |
| From | rja.carnegie@gmail.com |
| Injection-Date | Fri, 15 Feb 2013 11:27:18 +0000 |
| Content-Type | text/plain; charset=ISO-8859-1 |
| X-Received-Bytes | 2217 |
| Xref | csiph.com comp.databases.ms-sqlserver:1394 |
Show key headers only | 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 | Unroll 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