title

sys.trusted_assemblies (Transact-SQL) | Microsoft Docs

ms.custom

ms.date

06/14/2017

ms.prod

sql

ms.technology

system-objects

ms.topic

language-reference

f1_keywords

trusted_assemblies_TSQL

trusted_assemblies

sys.trusted_assemblies_TSQL

sys.trusted_assemblies

dev_langs

TSQL

helpviewer_keywords

sys.trusted_assemblies

ms.assetid

author

VanMSFT

ms.author

vanto

monikerRange

>=sql-server-2017||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.trusted_assemblies (Transact-SQL)

Contains a row for each trusted assembly for the server.

Column name	Data type	Description
hash	varbinary(8000)	SHA2_512 hash of the assembly content.
description	nvarchar(4000)	Optional user-defined description of the assembly. Microsoft recommends using the canonical name that encodes the simple name, version number, culture, public key, and architecture of the assembly to trust. This value uniquely identifies the assembly on the common language runtime (CLR) side and is the same as the clr_name value in sys.assemblies.
create_date	datetime2	Date the assembly was added to the list of trusted assemblies.
created_by	nvarchar(128)	Login name of the principal who added the assembly to the list.

Remarks

Use Need to add sp_add_trusted_assembly and Need to add sys.trusted_assemblies add or remove assemblies from sys.trusted_assemblies.