I am using Red Gate's data compare and am getting the following error when i try and sync.
This software basically sync and compare MSSQL data between db's. ie Local and remove databases. I believe the issue is not with this software but with the database instances.
error occurred executing synchronization: There is insufficient memory in the buffer poo
both database that i am trying to sync are MSSQL 2008 R2