Quoted identifier support

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:

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.