sys.server_assembly_modules

Description

Contains one row for each assembly module for the server-level triggers of type TA. This view maps assembly triggers to the underlying CLR implementation. You can join this relation to. The assembly must be loaded into the (object_id) is the key for the relation. This is a FOREIGN KEY reference back to the object upon which this ID of the assembly from which this module was created. The assembly must be loaded into the master database.

Permissions

SQL) Article • 02/28/2023 Contains one row for each assembly module for the server-level triggers of type TA. This view maps assembly triggers to the underlying CLR implementation. You can join this relation to. The assembly must be loaded into the database. The tuple (object_id) is the key for the relation. Description This is a FOREIGN KEY reference back to the object upon which this assembly module is defined. ID of the assembly from which this module was created. The assembly must be loaded into the master database. Name of the class within assembly that defines this module. Name of the method within the class that defines this module. Is NULL for aggregate functions (AF). ID of the EXECUTE AS server principal. NULL by default or if EXECUTE AS CALLER. ID of the specified principal if EXECUTE AS SELF EXECUTE AS . -2 = EXECUTE AS OWNER. The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration. ﾉ Expand table See Also