Home Forums SQL Server 7,2000 Administration An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown. RE: An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.

  • July 11, 2012 at 5:56 am

    #1511461

    krishnaprasad14 (7/11/2012)

    Really can't modify anything.

    [My self I think 23,000 row count is not big for GB Ram server....]

    Thank you.

    It's the client limit, not the server, as Anthony pointed out in an earlier post.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden