Run once in each database containing the tables marked for incremental transfer to create the spt_TableTransfer table in this database.
sp_setup_table_transfer
Although it is optional, you should run sp_setup_table_transfer before you transfer a table. If you do not run sp_setup_table_transfer, the SAP ASE server automatically creates spt_TableTransfer when a table is marked for incremental transfer or when you perform the first transfer.
The permission checks for sp_setup_table_transfer differ based on your granular permissions settings.
Setting | Description |
---|---|
Enabled | With granular permissions enabled, you must be a user with manage database privilege. |
Disabled | With granular permissions disabled, you must be the daabase owner or a user with sa_role. |