Saturday, February 25, 2012

reporting software for end users

Hi,
Any suggestions for a ad hoc reporting software for end users?
Back end is sql server 2k.
Thanks"mecn" <mecn2002@.yahoo.com> wrote in message
news:eHxHZiEVHHA.5068@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Any suggestions for a ad hoc reporting software for end users?
> Back end is sql server 2k.
> Thanks
>
I'm always cautious when it comes to ad-hoc queries against a SQL Server. A
Bad query can impact performance.
Have you looked at SQL Server Reporting Services? Not really ad-hoc, but
some powerful stuff.
Or use Access. Just make sure the user only has select access, nothing
else.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

No comments:

Post a Comment