Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sys.server_sql_modules (Transact-SQL)

Contains the set of SQL modules for server-level triggers of type TR. You can join this relation to sys.server_triggers. The tuple (object_id) is the key of the relation.

Column Name

Data Type

Description

object_id

int

This is a FOREIGN KEY reference back to the server-level trigger where this module is defined.

definition

nvarchar(max)

SQL text that defines this module.

NULL = Encrypted.

uses_ansi_nulls

bit

Module was created with ANSI NULLS set option set to ON.

uses_quoted_identifier

bit

Module was created with QUOTED IDENTIFIER set option set to ON.

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.