sys-trusted-assemblies-transact-sql.md

title	sys.trusted_assemblies (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
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
caps.latest.revision
author	tmullaney
ms.author	thmullan;rickbyh
manager	jhubbard

sys.trusted_assemblies (Transact-SQL)

[!INCLUDEtsql-appliesto-ssvnxt-xxxx-xxxx-xxx]

Contains a row for each trusted assembly for the server.

Transact-SQL Syntax Conventions

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.

See Also

sys.sp_add_trusted_assembly sys.sp_drop_trusted_assembly DROP ASSEMBLY (Transact-SQL)
sys.assemblies
sys.dm_clr_loaded_assemblies