CLR using Threads & context connection=true

[adi_sesha]

Hi

I have a DLL deployed in SQL2005 which uses Thread pool. Since DLL exists in DB we can directly access it using context connection = true.

In my case the following works fine, if i execute the same out side Threadpool

SqlCommand cmd = new SqlCommand("select 1...", connection);
SqlContext.Pipe.ExecuteAndSend(cmd);

When i execute inside threadpool, either by passing opened connection object, or tried to open connection to "context connection = true" i am getting following error.

System.InvalidOperationException: The requested operation requires a Sql Server execution thread. The current thread was started by user code or other non-Sql Server engine code. at Microsoft.SqlServer.Server.SmiContextFactory.GetCu rrentContext() at Microsoft.SqlServer.Server.SqlContext.get_CurrentC ontext() at Microsoft.SqlServer.Server.SqlContext.get_Pipe() at hiqidty4.hiqidty4.Identify_Search(Object identifyin)

Atleast i want to open connection object referring to "context connection = true", any suggestions on the same will be appreciated.

Let me know if i am missing any more here

Thanks in advance