Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SSRS

Answered SSRS

  • Sunday, November 18, 2012 1:18 PM
     
     
    Sign In to Vote
    0
    Hi in ssrs where is our sql query will be stored permanently...

    N.suresh

     

All Replies

  • Sunday, November 18, 2012 1:34 PM
     
     
    Sign In to Vote
    0
    Stored? 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 PM
     
     
    Sign In to Vote
    0
    The 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 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Suresh,

    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.

    Regards,
    Charlie Liao

    Charlie Liao

    TechNet Community Support