asking for opinions

Hello,
I want to collect system information (e.g. who have what access to what
databases, how much space has been used by each database, what version of th
e
service pack installed, etc.) of our SQL 2000 server. I can get on the SQL
server and use the system stored procedures to get those information manuall
y
every time I need it. But I also need to show the information to the
managers and other system admins who don't deal with SQL server very often.
So I'm thinking about showing those information on the web which is only
accessible to a certain group of people. How people usually do it? If
coding is involved, which language (PHP, PERL ,etc) has a better handle of i
t
in terms of SQL server? I know some people use email notification to send
reports. But I prefer web. By the way, we don't use any reporting software
here, like Crystal Report. Anyway, I'd appreciate any ideas and advice.
Thanks,
BingI've done this at my last three jobs. Build the infrastructure for the info
you want to collect and use linked servers, DTS and a central DB to collect
and store. Summarize it through stored procs that are called via the web.
For ultra critical items, generate email alerts such as the creation of
objects in a locked down environment.
"bing" wrote:

> Hello,
> I want to collect system information (e.g. who have what access to what
> databases, how much space has been used by each database, what version of
the
> service pack installed, etc.) of our SQL 2000 server. I can get on the SQ
L
> server and use the system stored procedures to get those information manua
lly
> every time I need it. But I also need to show the information to the
> managers and other system admins who don't deal with SQL server very often
.
> So I'm thinking about showing those information on the web which is only
> accessible to a certain group of people. How people usually do it? If
> coding is involved, which language (PHP, PERL ,etc) has a better handle of
it
> in terms of SQL server? I know some people use email notification to send
> reports. But I prefer web. By the way, we don't use any reporting softwa
re
> here, like Crystal Report. Anyway, I'd appreciate any ideas and advice.
> Thanks,
> Bing