>>I have four worker process answering the Web site. On one specific option a user did on the Web site, this has triggered a very long SQL command on SQL Server resulting in that process ID to take pretty much 100% of the memory available to it.
>>
>>Until we stopped that process, we ended up with several errors like this:
>>
>>"Exception of type 'System.OutOfMemoryException' was thrown."
>>
>>When looking at the trace, it was normal to see that the trace was pretty much different for each of them as, when there is no more memory available to process a transaction, an error can happen everywhere.
>>
>>However, what I do not understand, is one of them has this scenario. The Stack Trace ends up with at System.Text.StringBuilder.ToString() as the last item in it. This is from this method:
>>
>>

>>        ' Equivalent of VFP StrTran()
>>        ' expC1 String
>>        ' expC2 Search for specific character
>>        ' expC3 Replace
>>        Public Function StrTran(ByVal tcSearchIn As String, ByVal tcSearchFor As String, _
>>         ByVal tcReplace As String) As String
>>            Dim loStringBuilder As StringBuilder = New StringBuilder(tcSearchIn)
>>            Return loStringBuilder.Replace(tcSearchFor, tcReplace).ToString()
>>        End Function
>>

>>
>>So, basically, because of a memory issue, the StringBuilder was not able to execute. However, as surprisingly as it gets, the insert into SQL Server to log this error worked.
>>
>>So, can anyone explain me why a simple command like that could trigger a 'System.OutOfMemoryException' when, at the same time, after it failed at that location, I was able to execute an insert into SQL Server?
>
>
>Michel,
>
>Not an answer to your question, but why do you use a StringBuilder() when you can do without ?
>
>I think this should be sufficient as the only statement of the method
>

>return tcSearchIn.Replace(tcSearchFor, tcReplace)
>

>
>Your approach creates a StringBuilder object, which creates a char array and both the char array and the StringBuilder have to be garbage collected at some point
>
>No big deal, but I couldn't help telling you

I thought StringBiulder.Replace() was more efficient (especially if the result is a shorter string)
How about passing the strings by ref and using StringBuilder() ?