Sunday, November 18, 2012 1:18 PMHi in ssrs where is our sql query will be stored permanently...
Sunday, November 18, 2012 1:34 PMStored? If you ruin stored procedure then it is stored in the database. If you run adhoc query , SQL Server engine will generate it and return the final result...
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance
Sunday, November 18, 2012 6:27 PMThe stored procedure is saved where ever you want it to be saved, As uri mentioned. If its set to run an ad hoc query it is saved in the rdl file that's created when your create a report. This is saved in the report database that you created when Ssrs was installed. This is normally called report server.
Monday, November 19, 2012 3:21 AMModerator
When creating a SQL Server Reporting Services (SSRS) report, the query will be stored in the RDL file. In SSRS 2008 R2 or later, if we use a share dataset in the report, then the query will be stored in the RSD file which we can set in the Project folder.
C:\Documents\Visual Studio 2008\Projects\ProjectName\ProjectName
If we use a store procedure, then the query will be stored in database as Uri said.
If you have any questions, please feel free to ask.
TechNet Community Support
- Marked As Answer by Charlie LiaoMicrosoft Contingent Staff, Moderator Monday, November 26, 2012 1:36 AM