sys.sp_drop_trusted_assembly (Transact-SQL)
Applies to: SQL Server 2017 (14.x) and later Azure SQL Managed Instance
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 isn't 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;
Related content
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin