---
title: "SQL Server Attributes"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/sqlserver/attributes
original: https://documentation.invantive.eu/en/datamodels/sqlserver/attributes
updated: 2026-11-18T23:25:49Z
license: https://documentation.invantive.eu/en/
---

# SQL Server Attributes

## Other

### analysis-enforce-row-uniqueness

Use for analysis only! Enforce rows to be unique.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### bulk-delete-page-size-rows

Number of rows to delete per batch when bulk deleting.

- Default: `3000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### bulk-insert-page-size-bytes

Approximate maximum size in bytes of batch when bulk inserting.

- Default: `10000000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### bulk-insert-page-size-rows

Number of rows to insert per batch when bulk inserting.

- Default: `3000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### bulk-insert-timeout-sec

Number of seconds after which a bulk insert times out

- Default: `300`
- Set from: connection string, set statement, provider file
- Defined by: SQL Server

### command-timeout-sec

Number of seconds after which a command times out.

- Set from: connection string, set statement, provider file

### connection-string-async-add

Should the 'Async' be added automatically to the connection string?

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: SQL Server

### connection-string-async-value

Size of the Async to be added to the connection string

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Server

### connection-string-multiple-active-result-sets-add

Should the 'MultipleActiveResultSets' be added automatically to the connection string?

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Server

### connection-string-multiple-active-result-sets-value

Value of MultipleActiveResultSets to be added to the connection string

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Server

### force-case-sensitive-identifiers

Consider identifiers as case-sensitive independent of the platform capabilities.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### forced-casing-identifiers

Forced casing of identifiers. Choose from: Unset, Lower, Upper and Mixed.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### invantive-sql-correct-invalid-date

Whether to correct dates considered invalid since they are before 01-01-1753. When nullable, they are removed. Otherwise they are replaced by 01-01-1753.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-forward-filters-to-data-containers

Whether to forward filters to data containers.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-shuffle-fetch-results-data-containers

Whether to shuffle results fetched from data containers.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-use-cache

Whether to cache the results of a query.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### log-native-calls-to-disk

Registers native calls to data container backend as disk files.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### log-native-calls-to-trace

Log native calls to data container backend on the trace.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### max-url-length-accepted

The maximum accepted URL length before raising an error.

- Default: `8000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### max-url-length-desired

The maximum desired URL length.

- Default: `8000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### maximum-length-identifiers

Non-default maximum length in characters of identifier names.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### maximum-number-of-pooled-connections

Maximum number of concurrent pooled connections.

- Set from: connection string, set statement, provider file

### maximum-sleep-acquire-pooled-connection-ms

Maximum time in ms to wait for acquiring a free connection from a pool of connections.

- Default: `30000`
- Set from: connection string, set statement, provider file

### maximum-sleep-acquire-unpooled-connection-ms

Maximum time in ms to wait for acquire a free connection when there is no connection pooling.

- Default: `60000`
- Set from: connection string, set statement, provider file

### minimum-command-timeout-sec

Minimum number of seconds after which a command times out.

- Default: `300`
- Set from: connection string, set statement, provider file

### minimum-connection-timeout-sec

Minimum connection timeout in seconds.

- Set from: connection string, set statement, provider file

### on-close-sql

Native SQL statements to execute directly before close.

- Set from: connection string, set statement, provider file

### on-open-sql

Native SQL statements to execute directly after open.

- Set from: connection string, set statement, provider file

### open-connection-interval-sec

Delay between retries in milliseconds when login fails.

- Default: `500`
- Set from: connection string, set statement, provider file

### open-connection-retries

Maximum number of retries when login fails.

- Default: `2`
- Set from: connection string, set statement, provider file

### partition-slot-based-rate-limit-length-ms

Total length in milliseconds across all slots of a partition-based rate limit.

- Default: `60000`
- Set from: connection string, provider file
- Defined by: Shared

### partition-slot-based-rate-limit-slots

Number of slots per partition-based rate limit. Null means no slot-based rate limit.

- Set from: connection string, provider file
- Defined by: Shared

### pooled-connection-monitor-interval-sec

Minimum interval in seconds between two connection pool monitor activations.

- Default: `60`
- Set from: connection string, set statement, provider file

### pooled-connection-release-obsolete-interval-sec

Minimum interval in seconds between two tries to release obsolete connections from the connection pool when above the preferred number of connections.

- Default: `60`
- Set from: connection string, set statement, provider file

### pooled-connections-monitoring

Enable monitoring of connections of connection pool for automatic cleanup of obsolete connections.

- Default: `True`
- Set from: connection string, set statement, provider file

### pre-request-delay-ms

Pre-request delay in milliseconds per request.

- Default: `0`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### preferred-number-of-pooled-connections

Preferred number of concurrent pooled connections.

- Set from: connection string, set statement, provider file

### prefix-bind-variable-in-list

Prefix for bind variables used in an IN-list

- Default: `i`
- Set from: connection string, set statement, provider file

### prefix-bind-variable-normal

Prefix for bind variables used in all cases except in an IN-list

- Default: `w`
- Set from: connection string, set statement, provider file

### prefix-renamed-columns

Prefix appended to columns whose names occur multiple times in the column list of a query

- Default: `column`
- Set from: connection string, set statement, provider file

### requested-page-size

Preferred number of rows to exchange per round trip; only effective on limited platforms such as AFAS Online.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### requests-parallel-max

Maximum number of parallel data requests from individual partitions on the data container.

- Default: `32`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### slot-based-rate-limit-length-ms

Total length in milliseconds across all slots of a slot-based rate limit.

- Default: `60000`
- Set from: connection string, provider file
- Defined by: Shared

### slot-based-rate-limit-slots

Number of slots of a slot-based rate limit. Null means no slot-based rate limit.

- Set from: connection string, provider file
- Defined by: Shared

### standardize-identifiers

Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### standardize-identifiers-casing

Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Shared

