SQL Test Fatal error while inserting some codes

Asked By 0 points N/A Posted on -
qa-featured

Hello,

I am 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

What could be the problem ?

Thank you !

 

 

System.OutOfMemoryException: Exception of type

'System.OutOfMemory' was thrown.

at System.Reflection.RuntimeAssembly._nLoad(AssemblyName

fileName, String codeBase, Evidence assemblySecurity,

RuntimeAssembly locationHint, StackCrawIMark& stackMark, IntPtr

pPrivHostBinder, Boolean throwOnFileNotFound, Boolean

forIntrospection, Boolean suppressSecurityChecks)

at

System.Reflection.RuntimeAssembly.InternalGetSatelliteAssembly(String

name, CultureInfo culture,Version version Boolean

throwOnFileNotFound,StackCrawIMark& stackMark)

System.Resources.ManifestBasedResourcesGroveler.GetSatelliteAssembly

(CutureInfo lookForCulture, StackCrawIMark & stackMark

Sustem.Resources.ManifestbasedResourcesGroveler.GrovelForResourceS

et(CultureInfo, culture, Dictionary'2 localResourceSets,Boolean

tryParents, Boolean createIfNotExists, StackCrawIMark& stackMark)

at

System.Resources.ResourceManager.InternalGetResourcesSet(CultureInfo

requestedCultuire.Boolean createIfNotExists, Boolean tryParents, StackCraw

IMark& stackMark)

at

System.Resources.ResourceManager.InternalGetResourcesSet(CultureInfo

requestedCultuire.Boolean createIfNotExists, Boolean tryParents, StackCraw

IMark& stackMark)

at System.Resources.ResourcesManager.GetObject(String name, CultureInfo culture,

Boolean wrapUnamanagedMemStream)

at Sustem.Resources.ResourceManager.GetObject(String name)

at (Object,String)

at #NBn.#oFe.InitializeComponent()

at #NBn,#ofe..ctor()

at #NBn.#oFe.ctor (#x unhandledExceptionHandled, #n report

ExceptionEventArgs)

at #NBn,#OBn. #ik(#ne)

at #m.#x.#pk (Exception, Boolean)

OK

SHARE
Answered By 0 points N/A #179235

SQL Test Fatal error while inserting some codes

qa-featured

Hello,

 

SSMS is limited to 2 GB of memory and that is why you get this error.

Try to output the result as a text by following steps:

Right-Click on the query windows > Results to > Results to Text

Or

Try to output the result to a file:

Right-Click on the query windows > Results to > Results to File > Run the query and select the location

Related Questions