Archive for

How to fix System.OutOfMemoryException when using SSMS

Problem: When executing a query through SSMS you get a System.OutOfMemoryException error “An error occurred while executing batch. Error message is: Exception of type ‘System.OutOfMemoryException’ was thrown.” Solution: SSMS is a 32 bit process. It is limited to 2GB memory.When using Grid Mode there is a 64 kb limit per database field. If the result … Continue reading