Excel Add-In for Microsoft SQL Server

Build 22.0.8462

Miscellaneous

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


PropertyDescription
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
OtherThese hidden properties are used only in specific use cases.
ReadonlyYou can use this property to enforce read-only access to Microsoft SQL Server from the provider.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462