| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.trusted_assemblies (Transact-SQL) |
sys.trusted_assemblies contains a row for each trusted assembly for the server. |
VanMSFT |
vanto |
randolphwest |
11/05/2024 |
sql |
system-objects |
reference |
|
|
|
>=sql-server-2017 || >=sql-server-linux-2017 || =azuresqldb-mi-current |
[!INCLUDE SQL Server SQL MI]
Contains a row for each trusted assembly for the server.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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. We recommend 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(7) | 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. |
[!INCLUDE sssql19-md] and previous versions require VIEW SERVER STATE permission on the server.
[!INCLUDE sssql22-md] and later versions require VIEW SERVER SECURITY STATE permission on the server.
Use sys.sp_add_trusted_assembly to add, and sys.sp_drop_trusted_assembly to remove assemblies from sys.trusted_assemblies.