Forum Replies Created

Viewing 15 posts - 151 through 165 (of 455 total)

  • RE: Server application unavailable...

    Can u please check the event log and post what error you find in there?

     

    Prasad Bhogadi
    www.inforaise.com

  • RE: Server application unavailable...

    Well both your Stored Procedures (based on what is DML used inside your sp) and Report Services can consume Tempdb space. Try to clear the TempDB and restart your SQL...

    Prasad Bhogadi
    www.inforaise.com

  • RE: Server application unavailable...

    You can configure the timeout setting in web.config files in your ReportServer and ReportManager folders, however it makes more sense to try and optimize your stored procedures to fetch data...

    Prasad Bhogadi
    www.inforaise.com

  • RE: Stored Procedures: 2005 to 2000

    Did you create the stored procedure using the Management Studio Script Creation Wizard? If so did you make sure you have Script for Server Version as SQL Server 2000? By...

    Prasad Bhogadi
    www.inforaise.com

  • RE: Subreports within table/matrix cells are ignored.

    Yes, this is a documented limitation in SQL Server Reporting Services.

     

    Prasad Bhogadi
    www.inforaise.com

  • RE: Server application unavailable...

    What is the amount of data that you are trying to render on your report. Also check the time taken and memory consumed when your running this report in the...

    Prasad Bhogadi
    www.inforaise.com

  • RE: Hide Parameters list when viewing report

    Check Allow Null, Allow Blank and Hidden Checkboxes in your Report Parameters window. This should suppress your Report Parameters getting displayed. Coming to not able to generate a report with...

    Prasad Bhogadi
    www.inforaise.com

  • RE: How to build this report?

    Well your cell width or length should not really stop you from displaying data as it grows if you set the CanGrow properties for the cell to true. Coming to...

    Prasad Bhogadi
    www.inforaise.com

  • RE: Refreshing All Tables in SQLServer 2005

    Import/Export will not try to create a new table if the table is already existing, however if there is some integrity problem then you may get some errors, so drop...

    Prasad Bhogadi
    www.inforaise.com

  • RE: Please Help. Sql Agent Hung

    Do you see any other errors in Event Viewer Log under Application and system.

     

    Prasad Bhogadi
    www.inforaise.com

  • RE: SP Problem

    I don't think the html tags enclosing the ABCD is same for all the rows in the column. If it is same you can just do this....

    declare

    ...

    Prasad Bhogadi
    www.inforaise.com

  • RE: Problems Configuration Report Server

    I am not sure why your Initialization is greyed out, you basically need to Initialize SQL Server Instance that is running the Reporting Services in order to access the Reporting...

    Prasad Bhogadi
    www.inforaise.com

  • RE: Date Checking

    I believe I was typing when you posted it

     

    Prasad Bhogadi
    www.inforaise.com

  • RE: Date Checking

    SELECT *,DATEDIFF(d,xdate1,GETDATE()) AS Days FROM sysxlogins WHERE xdate1 > DATEADD(d,-60,GETDATE())

    Should give the Logins created with in last 60 days

     

    Prasad Bhogadi
    www.inforaise.com

  • RE: Update with Select...

    Makes complete sense, how did I miss? It was academic

    Prasad Bhogadi
    www.inforaise.com

Viewing 15 posts - 151 through 165 (of 455 total)