Bonnie,
Yes, I'm actually executing the stored proc in Query Analyzer. That piece of code is a final Select in the stored proc.
I guess that the problem may be somehow related with collations. One of temporary tables is filled from a linked database with different collation.
>Alexander,
>
>The only other thing I can think to ask you is this: In Query Analyzer, are you actually executing the Stored Proc, or are you simply running the Select?
>
>~~Bonnie
>
>
>
>
>>Bonnie,
>>
>>I think, this cannot be the problem. This code is in middle tier and used to execute all stored procedures in the system. However, we don't have such problems with other stored procedures.
>>I didn't describe the code in all details. Connection property is static and returns existing SqlConnection object, if it was already created, or returns a new object from other class, as shown in my message.
>>
>>
>>>Alexander,
>>>
>>>Your code doesn't look too bad, but I wonder about the TransactionHolder.Connection property. It looks to me like you are creating a new Connection every time you access the property. I don't think this is what you want to do. Could this be the problem?
>>>
>>>~~Bonnie
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only