Does SQL Server handle unmanaged resources?

SQL Server does not handle the unmanaged resource of a framework. It has to be guaranteed by the framework DLL that it will clean up the unmanaged resource. SQL Server will not allow you to load .NET framework DLL which do not have clean up code for unmanaged resources.