Have Svr name, need DBs

20 Jan 2006 3:15 PM

Bob

Hello Folks!

I have a bunch of servers, actually there are about 340.

I have the names of the servers but what I'd like to do is loop through
the servers and return all the databases on those servers.

I'd also like to find out how busy the servers are.

Got any ideas?

Thanks-In-Advance

20 Jan 2006 3:46 PM

Jens

I wrote an SMO application for that. If you are interested, I can send
this to you. Though this is not yet perfect, it evaluates from the
needs of the community Just write me an email and I will share it. It
will eb additionally available on http://www.SQLServer2005.de (When the
site will be relaunched) soon.

HTH, Jens Suessmeyer.

20 Jan 2006 3:55 PM

Bob

Jens, please send me the file, my email address is B**@BobSweeney.Net

Also, what is an SMO application? Am I supposed to know what that
acronym is?

20 Jan 2006 4:00 PM

Mark Williams

Assuming that you have an account that has the appropriate login and
permissions, put the names of all the servers in a text file with one on each
line and run

for /F "tokens=1" %i in (servers.txt) do osql -S %i -E -Q
"sp_helpdb">>output.txt

The file output.txt will have have the listing of all the DBs on all the
servers.

For seeing how busy they are, use Performance Monitor (I think it's just
called "Performance" now) logs, or tool like MRTG.

--
If you posted to this forum through TechNet, and you found my answers
helpful, please mark them as answers.

Show quote

"Bob" wrote:

> Hello Folks!
>
> I have a bunch of servers, actually there are about 340.
>
> I have the names of the servers but what I'd like to do is loop through
> the servers and return all the databases on those servers.
>
> I'd also like to find out how busy the servers are.
>
> Got any ideas?
>
> Thanks-In-Advance
>
>

20 Jan 2006 5:51 PM

Mark Williams

Slightly cleaner output:

for /F "tokens=1" %i in (servers.txt) do osql -S %i -d "master" -E -Q
"select @@SERVERNAME UNION ALL select catalog_name from
information_schema.schemata"

--

Show quote

"Mark Williams" wrote:

> Assuming that you have an account that has the appropriate login and
> permissions, put the names of all the servers in a text file with one on each
> line and run
>
> for /F "tokens=1" %i in (servers.txt) do osql -S %i -E -Q
> "sp_helpdb">>output.txt
>
> The file output.txt will have have the listing of all the DBs on all the
> servers.
>
> For seeing how busy they are, use Performance Monitor (I think it's just
> called "Performance" now) logs, or tool like MRTG.
>
> --
> If you posted to this forum through TechNet, and you found my answers
> helpful, please mark them as answers.
>
>
> "Bob" wrote:
>
> > Hello Folks!
> >
> > I have a bunch of servers, actually there are about 340.
> >
> > I have the names of the servers but what I'd like to do is loop through
> > the servers and return all the databases on those servers.
> >
> > I'd also like to find out how busy the servers are.
> >
> > Got any ideas?
> >
> > Thanks-In-Advance
> >
> >