| 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)