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 sys.server_triggers. The assembly must be loaded into the master database. The tuple (object_id) is the key for the relation.
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 <principal>.
-2 = EXECUTE AS OWNER.
In SQL Server 2005 and later versions, 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. For more information, see Metadata Visibility Configuration.