SQL Remote User's Guide
  Setting Up SQL Remote
    Preparing your Adaptive Server Enterprise server

Ensuring TEMPDB is large enough

SQL Remote uses the TEMPDB database for the following purposes:

• The database extraction utility used to create remote databases uses TEMPDB to hold a temporary set of Adaptive Server Anywhere system tables.

• The Message Agent creates a temporary table called #remote when it connects to the server.

For these reasons, you should make TEMPDB larger than the 2 Mb default size. The size required depends on the number of tables and columns in your SQL Remote installation, but a size of 10 Mb is generally sufficient.