May 3, 2011 at 1:43 pm
i have implemented file reading and writing in CLR using scripting.textstream.
due to not proper exception handling. Exception encountered in somewhere middle of the execution of CLR SP. and it now have hold the input file and dont allow me to delete file.
when i execute sp again, it pops access denied error.
is there anyway to release all the stuck objects of clr?
please help.
May 3, 2011 at 1:50 pm
see if you can find the process associated with that AppDomain (look in the SQL Server error log and run sp_who2) then try to kill the process if it is still running.
Failing success with that I am thinking you might need to bounce SQL Server.
The probability of survival is inversely proportional to the angle of arrival.
May 3, 2011 at 2:02 pm
i know dropping and then creating assembly and stored procedure will solve the problem.
actually i have no. of dlls like that, and i will have to implement exception handling in all of them or dropping and creating all of them.
i am looking for solution that can be applicable on all of them. something like garbage collector or something.
May 3, 2011 at 2:07 pm
please help guys.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply