Database

Only one field per file with a format B(inary) can exceed 255 bytes in length.
C(haracter) fields can not exceed 2000 bytes.
There is a maximum of 255 fields per file.
File-name length is limited to 23 bytes.
Index-name length is limited to 22 bytes.
IDX Key is limited to 255 bytes.
A maximum of 4G - 1 rows per IDT.
LOB columns are limited to 16 MB.

Object Names

identifiers must not exceed 32 bytes in length
MS-SQL: Only regular identifiers are supported (up to 32 bytes in length)

IDENTITY functions (MS-SQL Server)

SCOPE_IDENTITY()
will return the last
IDENTITY
value inserted into an
IDENTITY
column in the same scope. Two statements are in the same scope if they are in the same stored procedure, function, or batch. Since it returns values inserted only within the current scope, it will not report on the
IDS_UPD_SYNC_TXN
table.
IDENT_CURRENT
(’Table name’) will return the last
IDENTITY
value generated for the specified table in any session and any scope. Since it returns values inserted only in the specified table, it will not report on the
IDS_UPD_SYNC_TXN
table.

Synchronizer

Maximum of 36 PK fields per IDT.
Each PK field value must be less than 1000 bytes in length
The combined length of PK field names and PK field values can not exceed 2000 bytes.

Servers

Maximum of 1024 TCP/IP connections per Server
Maximum of 4096 database connections per Database Module (
ssadbm.dll
).