Verify Managed Assembly Version in SQL Server Database

Question

I need to find out the version of the assembly deployed to the SQL Server database.
I need to do this through a script or other programmatic way to find out if I need to redistribute the assembly.

Any ideas?

Thanks.

Answer 1

This should help..

Syntax
ASSEMBLYPROPERTY ('assembly_name', 'property_name')
schema_name . The name of the assembly.

file_name Is the name of the property from which Information can be obtained. property_name can be one of the following values.

CultureInfo .
PublicKey .
MvID , .

VersionMajor ( ) .

Minor ( ) .

VersionBuild ( ) .

VersionRevision ( ) .
SimpleName .
.
CLRName , , , , . (CLR) .