Out of memory (error code)

• kzychu

  SSC Journeyman

  Points: 75

  More actions

  January 13, 2023 at 10:22 am

  #4137305

  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?

  Regards

  Chris

• ratbak

  Ten Centuries

  Points: 1157

  More actions

  January 13, 2023 at 2:12 pm

  #4137411

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