Export (0) Print
Expand All
Expand Minimize

sys.server_assembly_modules (Transact-SQL)

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.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft