Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
APPLICATIONNAME | nvarchar(200) | Default = app_name() | Identifies a specific application or process on whose behalf a change occurs | |
USERNAME | nvarchar(128) | Default = original_login() | Identifies a specific user on whose behalf a change occurred | |
DESCRIPTION | nvarchar(331) (Computed) | |||
DATEADDED | datetime | Default = getdate() | The date the row was added to the CHANGEAGENT table | |
PROCESSNAME | nvarchar(255) | Default = '' | Identifies the process used to make the change | |
PROCESSDISPLAYNAME | nvarchar(255) (Computed) | |||
SERVERNAME | nvarchar(255) | Default = @@servername |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_CHANGEAGENT_DATEADDED | DATEADDED | |||
PK_CHANGEAGENT | ID | |||
UIX_CHANGEAGENT_APPUSER_PROCESSNAME | USERNAME, APPLICATIONNAME, PROCESSNAME, SERVERNAME |
Entity-Relationship diagram of this table (IDSETREGISTERADHOCQUERY-SMARTQUERYINSTANCE)
Entity-Relationship diagram of this table (SQLFUNCTIONCATALOG-USERSETTINGS)