An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown

Error message on SSMS:

An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.

Cause:

Management Studio is running out of memory.

What to do?:

As a lot of computers issues, the most simple way to deal with it is to close the SSMS and open it again…