Microsoft Dynamics AX 2009 做同步数据库时出现 Buffer size 错误

Error

The total, internal size of the records in your joined SELECT statement is 67356 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 66560 bytes.

It is strongly recommended that you split your table(s) into smaller units.

Alternatively, you have to specify a 'Buffer size' value of 66 Kbytes or higher in the 'SQL' tab page in the Microsoft Dynamics Configuration Utility. The default value is 24 Kbytes.

Resolution

Start > Administrative Tools > Microsoft Dynamics AX 2009 Server Configuration > Database Tuning > Maximum buffer size

增加此值即可，但不要一次设置太大，尽量不要超过100。