sys.server_assembly_modules (Transact-SQL)sys.server_assembly_modules (Transact-SQL)

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

类型为 TA 的服务器级别触发器的每个程序集模块在表中对应一行。Contains one row for each assembly module for the server-level triggers of type TA. 此视图将程序集触发器映射到基础 CLR 实现。This view maps assembly triggers to the underlying CLR implementation. 您可以加入到此关系sys.server_triggersYou can join this relation to sys.server_triggers. 程序集必须加载到数据库。The assembly must be loaded into the master database. 元组 (object_id) 是该关系的键。The tuple (object_id) is the key for the relation.

列名Column name 数据类型Data type 描述Description
object_idobject_id intint 这是对定义此程序集模块所依据对象的反向 FOREIGN KEY 引用。This is a FOREIGN KEY reference back to the object upon which this assembly module is defined.
assembly_idassembly_id intint 创建此模块所基于的程序集的 ID。ID of the assembly from which this module was created. 此程序集必须加载到 master 数据库中。The assembly must be loaded into the master database.
assembly_classassembly_class sysnamesysname 定义此模块的程序集内的类的名称。Name of the class within assembly that defines this module.
assembly_methodassembly_method sysnamesysname 定义此模块的类中的方法的名称。Name of the method within the class that defines this module. 对于聚合函数 (AF),该列为 NULL。Is NULL for aggregate functions (AF).
execute_as_principal_idexecute_as_principal_id intint EXECUTE AS 服务器主体的 ID。ID of the EXECUTE AS server principal.

默认情况下,或者 EXECUTE AS CALLER 时,为 NULL。NULL by default or if EXECUTE AS CALLER.

指定主体 if 的 ID 执行 AS SELF EXECUTE AS<主体 >。ID of the specified principal if EXECUTE AS SELF EXECUTE AS <principal>.

-2 = EXECUTE AS OWNER。-2 = EXECUTE AS OWNER.

权限Permissions

目录视图中仅显示用户拥有的安全对象的元数据,或用户对其拥有某些权限的安全对象的元数据。The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. 有关详细信息,请参阅 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

请参阅See Also

目录视图 (Transact-SQL) Catalog Views (Transact-SQL)
对象目录视图(Transact SQL)Object Catalog Views (Transact-SQL)