MSSQL specify number of jobs - Error

[MichalisDBA]

Hi @osalvador.

When you specify number of jobs for source Microsoft SQL Server, for example jobs=2, ReplicaDB throws an error

Incorrect syntax near 'ABS'.

I think you missed an AND on file SQLServerManager.java line 383.

Instead of

sqlCmd = sqlCmd + " where " + options.getSourceWhere() + " ABS(CHECKSUM(%% physloc %%)) % " + (options.getJobs()) + " = ?";

i believe must be

sqlCmd = sqlCmd + " where " + options.getSourceWhere() + " AND ABS(CHECKSUM(%% physloc %%)) % " + (options.getJobs()) + " = ?";