Exceeding the Maximum Record Size

This section applies to Microsoft SQL Server.

The DATABridge Client also splits tables having a record size that exceeds the database’s maximum allowable record size (8032 for SQL Server). This is the relational database (not DATABridge) maximum for records. (SQL Server however, allows larger record sizes for text and image data type records.)

The following message is displayed in SQL Server when the record size exceeds 8032 characters:

WARNING: Table 'tablename' exceeds max record size of 8032 bytes; table 'tablename1' will be used for additional columns