Out of memory (error code)

  • hi

    I have a problem. I have created a report which shows the data from table in SQL Server (just a "select * from

    where catid in (..)).

    There is a parameter where I can choose if it should show MAIN categories, OTHER categories or ALL categories - and depend on choose - the list of catid is shorter or longer.

    It works fine when I choose MAIN or OTHER categories. But when I choose ALL - after some time I receive an error - out of memory.

    Result of this select (for all categories) is quite big - 25k records, but it should just be shown - there are no calculations in the report.

    What is more strange - this worked a month ago for me and other people, but a week ago in stopped working on my collegue's computer, but still worked on mine. Today it stopped working also on mine.

    I tried to restart (local machines, SQL server) - nothing helped.

    Do you have any idea why it happened like that and how to fix it?



  • Responses are going to https://www.sqlservercentral.com/forums/topic/out-of-memory-error-code-2 (duplicate posts)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply