Excel Add-In for SQL Server

Build 21.0.7958

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 SQL Server from the provider.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7958