In version 12.5, quoted identifiers will be forwarded to remote servers that support them. This is triggered by a set command:
set quoted identifier on
If this thread property is enabled, CIS will quote identifiers before sending SQL statements to remote servers.
Remote servers must have the ability to support quoted identifiers. There is a capability in the sp_capabilities result set reserved for this purpose:
Capability id: 135
Capability name: quoted identifier
Capability value: 0 = no support; 1 = supported
The capability defaults to 0 for Direct Connects that do not provide a value for this capability. Lack of support for this ability has resulted in CR 140298.
