Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
| Column name | Data type | Description |
|---|---|---|
object_id |
int |
This is a FOREIGN KEY reference back to the object upon which this assembly module is defined. |
assembly_id |
int |
ID of the assembly from which this module was created. The assembly must be loaded into the master database. |
assembly_class |
sysname |
Name of the class within assembly that defines this module. |
assembly_method |
sysname |
Name of the method within the class that defines this module. Is NULL for aggregate functions (AF). |
execute_as_principal_id |
int |
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. |
See Also
Reference
Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)