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, Sybase recommends you run sp_setup_table_transfer before you transfer a table. If you do not run sp_setup_table_transfer, Adaptive 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.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage database privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be the daabase owner or a user with sa_role. |
