v-wywang
11/27/2007 9:14:00 AM
Hello Scott,
It sound like your main concern is if closing/disposing the connection in
SQLCLR code will effect on the caller's ability to continue to use the
connection, correct? Please don't hesitate to correct me, if I
misunderstood anything again.
SQL CLR creates new connection with the same context of caller's connection
in his code. It doesn't use caller's connection. They are not the same
connection. Thereby, (as far as I know), whatever we do on the context
connection, this will not effect on the caller's connection.
Hope this helps. Please feel free to update here again, if there is
anything unclear. We are glad to assist you.
Have a great day,
Best regards,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.