sys.trusted_assemblies (Transact-SQL)
Applies to: SQL Server Azure SQL Managed Instance
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. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Remarks
Use sys.sp_add_trusted_assembly to add and sys.sp_drop_trusted_assembly to 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
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho