SQL Test Fatal error while inserting some codes

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