>>Hi
>>
>>I have a stored procedure I am running in management studio.
>>
>>The stored procedure loops through a table and inserts items into some other tables.
>>
>>I've wrapped each loop in a transaction and commit the transaction at the end of the loop.
>>
>>after the stored procedure has been running through a couple of thousand records
>>
>>I get this error
>>
>>An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.
>>
>>the stored procedure carries on.
>>
>>Any ideas what this error is about.
>>
>>Thanks
>
>The exception is from .NET. Do you call any .NET code in stored procedure?
>
>MartinaJ

Hi Martina

no NET code in there.