...
When distributing data to an SQL Server table, the following must be taken into consideration:
The table must have at least one UNIQUE column.
The column reserved for the Transaction ID must be of type
bigint.Columns of type UNIQUEIDENTIFIER must be set with a function. Hence, map it to NULL in the agent.
Columns with an IDENTITY set, must be mapped to NULL in the agent.
| Note |
|---|
...
Note! For MS SQL, the column |
...
type timestamp |
...
is not supported in tables accessed by |
...
Usage Engine. Use column |
...
type datetime |
...
instead. |
...
See Administrator( |
...
3.1) for more information about |
...
timezone settings. |