Stored procedures and SQL Server reporting services reports

niceguy971
niceguy971 used Ask the Experts™
on
When it's recommended to use stored procedures with Reporting services Reports?

SP need to be used for Web-project (preferred way)... Does the same apply to SSRS??

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
It is always recommended to use stored procedure than sql query. In sql queries there is always a change of sql injestion, a security risk. Apart from that, stored procedure makes the life easier as with every change in the logic, you don't have to redeploy your rdl, but just changes in the backend with the stored procedure will be sufficient.

Again, stored procedure will cache the plan, so its execution will be faster.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial