Excel Add-In for Microsoft SQL Server

Build 25.0.9434

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
MaxRowsSpecifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY.
OtherSpecifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details.
ReadonlyToggles read-only access to Microsoft SQL Server from the provider.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434