Online Documentation for SQL Manager for SQL server

Connection settings

The Connections section of the Server Properties dialog allows you to configure the instance of Microsoft® SQL Server by setting options pertaining to connection in groups: Connections, Remote server connections.




Maximum number of concurrent connections

If this option is set to a value other than zero, the number of connections that SQL Server will allow is limited. The default value is 0 (unlimited).


Server Properties - Connections


Default connection options

Specifies the default connection options as described in the table below:


Configuration option




CheckBox Disable deferred constraint checking


Controls interim or deferred constraint checking.

CheckBox Implicit transactions


Controls whether a transaction is started implicitly when a statement is run.

CheckBox Cursor close on COMMIT


Controls behavior of cursors after a commit operation has been performed.

CheckBox ANSI warnings


Controls truncation and NULL in aggregate warnings.

CheckBox ANSI padding


Controls padding of fixed-length variables.



Controls NULL handling when using equality operators.

CheckBox Arithmetic abort


Terminates a query when an overflow or divide-by-zero error occurs during query execution.

CheckBox Arithmetic ignore


Returns NULL when an overflow or divide-by-zero error occurs during a query.

CheckBox Quoted identifier


Differentiates between single and double quotation marks when evaluating an expression.

CheckBox No count

Turns off the message returned at the end of each statement that states how many rows were affected.


CheckBox ANSI NULL default on

Alters the session's behavior to use ANSI compatibility for nullability. New columns defined without explicit nullability are defined to allow nulls.


CheckBox ANSI NULL default off

Alters the session's behavior not to use ANSI compatibility for nullability. New columns defined without explicit nullability are defined not to allow nulls.


CheckBox Concat NULL yields NULL


Returns NULL when concatenating a NULL value with a string.

CheckBox Numeric round abort


Generates an error when a loss of precision occurs in an expression.

CheckBox Xact abort

Rolls back a transaction if a Transact-SQL statement raises a run-time error.



Remote Server Connections


CheckBox Allow remote connections to this server

Controls the execution of stored procedures from remote servers running instances of SQL Server. Selecting this check box has the same effect as setting the sp_configureremote access option to 1. Clearing it prevents execution of stored procedures from a remote server.


Remote query timeout (in seconds, 0 = no timeout)

Specifies how long (in seconds) a remote operation may take before SQL Server times out. The default is 600 seconds, or a 10-minute wait.


CheckBox Require distributed transactions for server-to-server communication

Protects the actions of a server-to-server procedure through a Microsoft® Distributed Transaction Coordinator (MS DTC) transaction.