Trigger Context Connection is Already in use by Other Session.
I have Created CLR Trigger(SQL Server Project) Project.
In that project i have used the Following Code. // Some Proceesing based on the row Inserted. con.Close(); After Closing the Connection I want to open a New SqlConnection for other Database like below. string
SqlConnectioncon =newSqlConnection("context connection = true");
con.Open();
con.Open();
When i try to do this its giveing the following error:
Error:-
Trigger Context Connection is Already in use by Other Session.
Is it not possible to open a new conncetion for Other database from the CLR Trigger Project?
If anybody knows the solution let me know to solve it.
Thanks
Vinoth

