sp_setup_table_transfer

Run once in each database containing the tables marked for incremental transfer to create the spt_TableTransfer table in this database.

Syntax

sp_setup_table_transfer

Usage

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.

Permissions

The permission checks for sp_setup_table_transfer differ based on your granular permissions settings.

SettingDescription
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.