FIX: SHARING VIOLATION error 6518 occurs on CLR assembly microsoft.sqlserver.types.dll in SQL Server 2012 or SQL Server 2014

Applies to: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Standard

Symptoms


When you run queries in Microsoft SQL Server 2012 or SQL Server 2014, the queries may intermittently fail with a SHARING VIOLATION error on the CLR assembly Microsoft.SqlServer.Types.dll. Additionally, the following error message is logged in SQL Server Error log:
Error 6518, Severity 16, State 2
Could not open system assembly ''C:\Windows\assembly\GAC_MSIL\microsoft.sqlserver.types\11.0.0.0__89845dcd8080cc91\microsoft.sqlserver.types.dll'': 32(The process cannot access the file because it is being used by another process.).

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.