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?

     

  • 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...

  • 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...

  • 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...

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

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

     

  • 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...

  • 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...

  • 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...

  • 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...

  • RE: Please Help. Sql Agent Hung

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

     

  • 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

    ...

  • 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...

  • RE: Date Checking

    I believe I was typing when you posted it

     

  • 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

     

  • RE: Update with Select...

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

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