Connection Properties Tab, Options Dialog Box
Use the Connection Properties tab on the Options dialog box to specify SET options for all new connections.
Note The options on the Connection Properties tab of the Options dialog box are the same as those on the Current Connection Properties dialog box. However, connection properties set in the Options dialog box affect new connections. Options set in the Current Connection Properties dialog box affect only the current connection.
Suppress the rowcount message. This setting reflects the SET NOCOUNT ON/OFF state set in a query or stored procedure. For more information, see SET NOCOUNT in SQL Server Books Online. The default setting is OFF.
Compile, but do not execute, the statements. This setting is useful for validating syntax and object names. It is also useful for debugging statements that may be part of a larger batch of statements. The default setting is OFF.
Parse the syntax but do not compile or execute the statements. This option does not validate object names. The default for this setting is OFF.
Return NULL if any operand in a concatenation operation is NULL.
Return the specified number of rows and stops the query. The default (0) returns all rows.
Terminate a query when an overflow or divide-by-zero error occurs during query execution.
Show execution information but do not execute.
Set statistics time
Show the number of milliseconds required to parse, compile, and execute statements. The default setting is OFF.
Set statistics IO
Show information about disk activity. The information includes the name of the table being used, the number of scans performed, the number of pages read from the data cache and the disk, and the number of pages placed into the cache for the query. The default setting is OFF.
Show stats I/O
Specify that the information regarding disk activity generated by each query statement be shown.
Set the options in this group to comply with SQL-92.
|Set ansi nulls||Return UNKNOWN if a comparison operator has any null expressions. This option sets the ANSI_NULLS option to ON. The ANSI syntax "IS NULL" or "IS NOT NULL" must be used for all null comparisons. If the ANSI_NULLS option is OFF, comparisons of all data against a null value evaluate to TRUE if the data value is NULL.|
|Set ansi_null_dflt_on||Overrides the default nullability for new columns.|
|Set ansi_padding||Do not automatically truncate trailing blanks and trailing zeros. This option sets the ANSI_PADDING option to ON. Trailing blanks on varchar values and trailing zeroes on varbinary values are not truncated automatically.|
|Set ansi_warnings||Issue warnings on certain error conditions. This option sets the ANSI_WARNINGS option to ON. SQL Server issues warning messages for conditions that violate ANSI rules but do no violate the rules of Transact-SQL.|
|Set cursor_close_on_commit||Close cursors when a transaction commits.|
|Set implicit_transactions||Begin transactions automatically, without explicit BEGIN TRANSACTION statements.|
|Set quoted_identifier||Interpret characters enclosed in double quotation marks as identifiers. This option sets the QUOTED_IDENTIFIERS option to ON when the SQL Server ODBC driver connects. The default for this setting is OFF. For more information, see SET QUOTED_IDENTIFIERS in SQL Server Books Online.|
Restore all connection properties to their initial settings.