MSDN does not list all parameters for this stored procedure. You may want to see the stored procedure text to detect them (like ‘batch_size’).

Also, do check the allowed ranges for the parameters, because the error message provided by the sp is very unhelpful (for example, we’ve tried batch_size 1 when the minimum allowed size is 100 and we only found out the problem after tracing the stored procedure with the debugger).

Advertisements