Configuring the tempdb database

ASE Replicator uses a temporary table created by a stored procedure to manage its log truncation process. This requires that you set the ddl in tran option in the tempdb database.

StepsTo configure the tempdb database

  1. Log in to the primary Adaptive Server with a System Administrator user role.

  2. Set the ddl in tran option for the tempdb database:

    use master
    sp_dboption tempdb, "ddl in tran", true
    
  3. Run the checkpoint command in the tempdb database.