CLR stored procedure cross base access

[Yoyosch]

I implementd CLR stored procedure on 'Database1'. I would like to perform some UPDATE statements inside this CLR stored procedure in 'Database2'. Is is possible? If so, then how?

[Mycroft Holmes]

You can have a use database statement in your proc. I have not idea how you do that in the clr, I have never turned it on, I use TSQL. You will find there are very few devs use the clr, most will use TSQL and sql servers SSMS tool. You do not need another layer of abstraction between you and your data.

Never underestimate the power of human stupidity RAH