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

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

Re: List all databases on all servers

Show all headers | View raw

> 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?

I have no intention of blocking anybody. In fact I would like to encourage 
others to work in SQL instead of making a mess of things using another 
database tool. As before, I just want to try and ensure those that do setup 
SQL databases, comply to a few default standards.

> Maybe use the firewall as the source of the current list of
> SQL Server names?
That might be the case, but again that will be external to T-SQL and 
scripted seperately, in which case I might as well use powershell or OSQL

> (Then, would they be able to install sneaky extra instances without
> telling you?)
Not trying to block anybody from installing it.

> Presumably someone's buying /licences/ for all your SQL Servers,
> so could you get the information from the company accounting
> system?
We have Enterprise data centre license, so nobody needs to track or buy any 
licenses. (But also Express editions could be installed without license)

> Or, get hold of one of those viruses
Hah... yep good idea, but still it will be a seperate script and I was 
hoping to run it all from within SSMS in one script :)

>  Then you can take care of all our backups
> as well...
I do not want to take care of backups, my intention is only to check whether 
our standard guidelines are being followed. If not I will contact the person 
responsible for the database and advise. I will then mark the database in 
question as "advised" and ignore it from then on.

It might also give me a good idea of who in our organisation are interested 
or working in SQL servers and allow us to get together and share ideas to 
work collaboratively from time ti time.

I also intend to later modify my script to also check other things like 
space used and available to log these into a table daily to allow me to 
create a report on growth in space used and assess our future requirements.

I might look at policy based management to see what it offers. Not sure it 
will give me what I am after and I think the simplest solution at present is 
merely to script the discovery via powershell, then the query in T-SQL

regards
C

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