I am having some dificulties with the extended procedure sp_OACreate, only when using the SQL Server 2005. I am using some COM+ objects inside a procedure, and to access these objects and create them I was using these extended procedures : sp_OACreate,
I created a UDF in C#. This works fine but I am worried about performance. When does the CLR load into the SQL Server process space? How long does the CLR stay resident?