"version" incorrectly showing as in sys.assemblies and ASSEMBLYPROPERTY(name, 'CLRName') for unsigned SQLCLR Assemblies - by Solomon Rutzky

Status : 


Sign in
to vote
ID 2295108 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 1/28/2016 3:10:41 PM
Access Restriction Public


If you set the AssemblyVersion (e.g. [assembly: AssemblyVersion("")] ) of a SQLCLR Assembly but do not sign the Assembly / give it a Strong Name, then the "version" info in the [clr_name] field of the [sys].[assemblies] catalog view will show "". It will only show the actual AssemblyVersion if the Assembly is signed. However, the AssemblyVersion info shows correctly everywhere else.

I just checked the definition of [sys].[assemblies] and found that the [clr_name] field is merely the output of the following built-in function, which is then technically the true source of the problem:


I have tested this in the following versions of SQL Server:
2005, SP4
2008 R2, SP3
2012, SP3
2014, SP1
2016, SP1
2017 RC2 (Linux)
Sign in to post a comment.