Online Documentation for SQL Administrator for SQL Server

Connections


The Connections section of the Server Properties dialog allows you to configure the instance of Microsoft® SQL Server by setting options pertaining to connection.

 

Server properties - Connections

 

 

Maximum number of user 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).

 

Estimated query cost limit in seconds

Use this field to specify an upper limit on the time period in which a query can run. Queries that have estimated run times greater than this limit, return an error and are not executed. Query cost refers to the estimated elapsed time, in seconds, required to complete a query on a specific hardware configuration.

 

Outgoing remote query timeout in seconds

Use this field to specify how long, in seconds, a remote operation can take before Microsoft SQL Server times out. The default is 600, which allows a 10-minute wait. This value applies to an outgoing connection initiated by the Database Engine as a remote query. This value has no effect on queries received by the Database Engine.

 

!CheckBox Allow remote SQL Servers to connect 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.

 

!CheckBox 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.

 

Default connection options

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

 

Configuration option

 

Description

 

!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 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 NULLs

 

Controls NULL handling when using equality operators.

!CheckBox ANSI padding

 

Controls padding of fixed-length variables.

!CheckBox ANSI warnings

 

Controls truncation and NULL in aggregate warnings.

!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 Close cursor on COMMIT

 

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

!CheckBox Concat NULL yields NULL

 

Returns NULL when concatenating a NULL value with a string.

!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 No count

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

!CheckBox Numeric round abort

 

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

!CheckBox Quoted identifier

 

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

!CheckBox Xact abort

 

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