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 the
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 manually
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 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 SQL
> server and use the system stored procedures to get those information manually
> 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 software
> here, like Crystal Report. Anyway, I'd appreciate any ideas and advice.
> Thanks,
> Bingsql