CODEWITHSUNDEEP
sqlsql-servert-sql
Kobojunkie
Kobojunkie

Reputation: 6545

SQL Server 2012 OUT OF MEMORY error messages

I am trying to trying to run some insert code(about 40,000 of them) using SSMS but I keep running up against SQL out of memory errors among others. I would appreciate any help to fix this problem please.

**Error message that shows up when I try to run my query**

**Another SQL Error message that showed up as well** Database Property

Upvotes: 2

Views: 4558

Answers (2)

Kobojunkie
Kobojunkie

Reputation: 6545

After hours of digging, I decided to uninstall all of the Redgate tools that I had been using with my SQL installation. It seems that the problem was being caused by one of these tools.

Upvotes: 0

usr
usr

Reputation: 171178

This exception is a .NET exception, so it cannot come from SQL Server. It comes from SSMS itself. Your machine has not enough ram.

OutOfMemoryException also has nothing to do with disk space. It refers to RAM.

Upvotes: 3

Related Questions