Set query items limit
Explanation
This policy setting allows you to specify the maximum number of items that will be added to the client’s cache as the result of executing a query. Several bulk operations (especially queries) can return a large number of items to be added to the cache. This increases the size of the cache, potentially exceeding the 4GB limit imposed by Microsoft SQL Server CE. It also increases the amount of work required to keep the cache synchronized and increases the load on the LOB server. In order to protect the system, a limit is used – any results processed before reaching the limit are still committed, but the operation is marked as failed and will be retried later.
If you enable this policy setting, you may specify the maximum number of items that will be added to the client’s cache as the result of executing a query.
If you disable or do not configure this policy setting, a default value of 2000 items will be used.
Registry
HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\common\business data\synchronization- Value name
- not defined in the ADMX
Enable / disable values: not defined in the ADMX (see the options below).
PowerShell
PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.
Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.
Enable
# Enable: office16/L_QueryInstancesLimit
$k = 'HKCU:\software\policies\microsoft\office\16.0\common\business data\synchronization'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# Query instances limit
Set-ItemProperty -Path $k -Name 'query instances limit' -Value 1 -Type DWord # between 1 and 32767Disable
# Disable: office16/L_QueryInstancesLimit
# No value is written in the "Disabled" state (nothing defined in the ADMX)Revert to "Not configured"
# Revert to "Not configured": office16/L_QueryInstancesLimit
$k = 'HKCU:\software\policies\microsoft\office\16.0\common\business data\synchronization'
Remove-ItemProperty -Path $k -Name 'query instances limit' -ErrorAction SilentlyContinueOptions (1)
| Label | Control | Registry value | REG type | Constraints / details |
|---|---|---|---|---|
| Query instances limitL_QueryInstancesLimitDecimal | Numeric boxdecimal | query instances limit | REG_DWORD | Min: 1 · Max: 32767 |
Application
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.