How do you check the version number of a sql server clr?

Question

What is the best way to check / version a sql server clr? I am currently creating a SqlFunction that returns a version number (which I set before release). This allows me to query the version e.g.

select mySchema.GetClrAppVersion

Any thoughts or ideas would be appreciated.

score 1 · Accepted Answer · answered Oct 02 '12 at 19:59

1

ASSEMBLYPROPERTY()

SEE: http://msdn.microsoft.com/en-us/library/ms188750.aspx

answered Oct 02 '12 at 19:59

etliens

1,352
9
16

How do you check the version number of a sql server clr?

1 Answers1