Script to enumerate user databases on a remote server

Hello there
I want to know if there is an already written script outhere that can give
me an enumeration of all user databases, and theire size ?
My end goal is to have a webpage I can logon into and I can check on the
report for sizes, backup jobs and .... if there is anyproduct that already
aggregate such data for multiple servers (12 in my case) then it will be
great.
thanksHi,
You could use the system stored procedures
sp_helpdb
or
sp_databases
You use could use OSQL and execute this stored procedure in all server and
insert the data into one common table and then use that table in
displaying the web page.
Thanks
Hari
SQL Server MVP
"Simo Sentissi" <msentissi@.rightnow.com> wrote in message
news:eAiu706lFHA.3568@.tk2msftngp13.phx.gbl...
> Hello there
> I want to know if there is an already written script outhere that can give
> me an enumeration of all user databases, and theire size ?
> My end goal is to have a webpage I can logon into and I can check on the
> report for sizes, backup jobs and .... if there is anyproduct that
> already aggregate such data for multiple servers (12 in my case) then it
> will be great.
> thanks
>
>|||Hari Prasad wrote:[vbcol=seagreen]
> *Hi,
> You could use the system stored procedures
> sp_helpdb
> or
> sp_databases
> You use could use OSQL and execute this stored procedure in all
> server and
> insert the data into one common table and then use that table in
> displaying the web page.
> Thanks
> Hari
> SQL Server MVP
>
> "Simo Sentissi" <msentissi@.rightnow.com> wrote in message
> news:eAiu706lFHA.3568@.tk2msftngp13.phx.gbl...
> can give
> on the
> that
> then it
Have you found an answer to this yet? If not I have script for you.
gills
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1768228.htmlsql