sys-sp-drop-trusted-assembly-transact-sql.md

title	sys.sp_drop_trusted_assembly (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_drop_trusted_assembly_TSQL sp_drop_trusted_assembly sys.sp_drop_trusted_assembly_TSQL sys.sp_drop_trusted_assembly
dev_langs	TSQL
helpviewer_keywords	sys.sp_drop_trusted_assembly
ms.assetid
author	VanMSFT
ms.author	vanto
monikerRange	>=sql-server-2017||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.sp_drop_trusted_assembly (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2017-xxxx-xxxx-xxx-md]

Drops an assembly from the list of trusted assemblies on the server.

Transact-SQL Syntax Conventions

Syntax

sp_drop_trusted_assembly 
    [ @hash = ] 'value'

Arguments

[ @hash = ] 'value'
The SHA2_512 hash value of the assembly to drop from the list of trusted assemblies for the server. Trusted assemblies may load when clr strict security is enabled, even if the assembly is unsigned or the database is not marked as trustworthy.

Remarks

This procedure removes an assembly from sys.trusted_assemblies.

Permissions

Requires membership in the sysadmin fixed server role or CONTROL SERVER permission.

Examples

The following example drops an assembly hash from the list of trusted assemblies for the server.

EXEC sp_drop_trusted_assembly 
0x8893AD6D78D14EE43DF482E2EAD44123E3A0B684A8873C3F7BF3B5E8D8F09503F3E62370CE742BBC96FE3394477214B84C7C1B0F7A04DCC788FA99C2C09DFCCC; 

See Also

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