Favorite reports

Is there any to let users have a folder of favorite reports?
I tried using "My Reports" folder, but the security required to allow a
user to see the option to create a linked report created too much of a
security risk.
Any ideas?Users could use the IE favorites, create a group there and simply add the
reports as you would any other web site...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Geddes" <john_g@.alamode.com> wrote in message
news:OxZbNxB9EHA.2900@.TK2MSFTNGP09.phx.gbl...
> Is there any to let users have a folder of favorite reports?
> I tried using "My Reports" folder, but the security required to allow a
> user to see the option to create a linked report created too much of a
> security risk.
> Any ideas?
>

Favorite Monitoring (Performance) Tools?

I'm fairly new to the DBA thing.
I've been doing quite a bit of research on monitoring MSSQL performance.

What tools are you guys using?
PerfMon, Dbartisan, Spotlight, or what?

I'd like to find some free or affordable way to watch our Servers to check health/performance/etc.If you're using SQL 2005 (SP2), you can use a combination of SQL Health and History (aka SQL H2) and the new SQL Dashboard. Both require SQL Reporting services.

I'm using a set of vb scripts that use WMI queries to gather basic information: storage, network config, os config, installed apps, memory and cpu utilization. These are stored in a database. You can do a google on "wmi computer inventory vb script" and I think it will come up with a variety of examples.

Regards,

hmscott|||"whatsup" has a lot of robust automation for wmi if you're looking for a prepackaged solution. We've had reasonable luck with it so far.