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:49 am

    #1511458

    krishnaprasad14 (7/11/2012)

    Hi Thank you for your replay. I was done this. I can execute if I change query results to text o file but geting an error when I choose grid. BUt user's want to see in grid formate

    Thank you

    23,000 rows doesn't seem much for this message to appear - on the other hand, nobody is going to scan this many rows by eye. Can't you restrict the rowcount to something more reasonable?

    “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