'System.OutOfMemoryException' was thrown. (mscorlib) in Sql Server 2008

Question

I am the following error on running a script!!!

===================================

Cannot execute script.

===================================

Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib)

------------------------------
Program Location:

   at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
   at System.Text.StringBuilder..ctor(String value, Int32 startIndex, Int32 length, Int32 capacity)
   at System.Runtime.InteropServices.Marshal.PtrToStringUni(IntPtr ptr)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ShellTextBuffer.GetText(Int32 startPosition, Int32 chars)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ShellTextBuffer.get_Text()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ShellCodeWindowControl.GetSelectedTextSpan()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptEditorControl.GetSelectedTextSpan()
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.OnExecScript(Object sender, EventArgs a)

Thanks in advance!!!

Javeed M Shaikh · Answer

It might be a limitation to execute larger scripts please try to break down the script in smaller chunks and try again. Please do not forget to mark Accepted Answer.

Sam Hobbs · Answer

You must determine what the source code line is that is getting ther error. No one inlcuding yourself can solve the problem otherwise.

Mittal Sejpal · Answer

sir It is u huge script containing around 31517 lines so i m not find out where exactly the error occurs!!1

Prabhu Raja · Answer

can you give you code snippets and Highlight Error Portions. Thank You