This section lists options alphabetically.
allow_nulls_by_default option [compatibility]
allow_snapshot_isolation option [database]
ansi_blanks option [compatibility]
ansi_close_cursors_on_rollback option [compatibility]
ansi_integer_overflow option [compatibility]
ansi_permissions option [compatibility]
ansi_substring option [compatibility]
ansi_update_constraints option [compatibility]
ansinull option [compatibility]
auditing option [database]
auditing_options option [database]
automatic_timestamp option [compatibility]
background_priority option [database]
blob_threshold option [SQL Remote]
blocking option [database]
blocking_timeout option [database]
chained option [compatibility]
checkpoint_time option [database]
cis_option option [database]
cis_rowset_size option [database]
close_on_endtrans option [compatibility]
collect_statistics_on_dml_updates option [database]
compression option [SQL Remote]
conn_auditing option [database]
connection_authentication option [database]
continue_after_raiserror option [compatibility]
conversion_error option [compatibility]
cooperative_commit_timeout option [database]
cooperative_commits option [database]
database_authentication [database]
date_format option [compatibility]
date_order option [compatibility]
debug_messages option [database]
dedicated_task option [database]
default_dbspace option [database]
default_timestamp_increment option [database] [MobiLink client]
delayed_commit_timeout option [database]
delayed_commits option [database]
delete_old_logs option [MobiLink client] [SQL Remote] [Replication Agent]
divide_by_zero_error option [compatibility]
encrypt_aes_random_iv option [database]
escape_character option [compatibility]
exclude_operators option [database]
extended_join_syntax option [database]
external_remote_options [SQL Remote]
fire_triggers option [compatibility]
first_day_of_week option [database]
float_as_double option [compatibility]
for_xml_null_treatment option [database]
force_view_creation option [database]
global_database_id option [database]
http_session_timeout option [database]
integrated_server_name option [database]
isolation_level option [compatibility]
java_location option [database]
java_main_userid option [database]
java_vm_options option [database]
log_deadlocks option [database]
login_mode option [database]
login_procedure option [database]
materialized_view_optimization option [database]
max_client_statements_cached option [database]
max_cursor_count option [database]
max_plans_cached option [database]
max_query_tasks option [database]
max_recursive_iterations option [database]
max_statement_count option [database]
max_temp_space option [database]
min_password_length option [database]
nearest_century option [compatibility]
non_keywords option [compatibility]
odbc_describe_binary_as_varbinary [database]
odbc_distinguish_char_and_varchar option [database]
oem_string option [database]
on_charset_conversion_failure option [database]
on_tsql_error option [compatibility]
optimistic_wait_for_commit option [compatibility]
optimization_goal option [database]
optimization_level option [database]
optimization_workload option [database]
percent_as_comment option [compatibility]
pinned_cursor_percent_of_cache option [database]
post_login_procedure [database]
precision option [database]
prefetch option [database]
preserve_source_format option [database]
prevent_article_pkey_update option [database] [MobiLink client]
qualify_owners option [SQL Remote]
query_plan_on_open option [compatibility]
quote_all_identifiers option [SQL Remote]
quoted_identifier option [compatibility]
read_past_deleted option [database]
recovery_time option [database]
remote_idle_timeout option [database]
replicate_all option [Replication Agent]
replication_error option [SQL Remote]
replication_error_piece option [SQL Remote]
request_timeout option [database]
return_date_time_as_string option [database]
ri_trigger_time option [compatibility]
rollback_on_deadlock [database]
row_counts option [database]
save_remote_passwords option [SQL Remote]
scale option [database]
secure_feature_key [database]
sort_collation option [database]
sql_flagger_error_level option [compatibility]
sql_flagger_warning_level option [compatibility]
sr_date_format option [SQL Remote]
sr_time_format option [SQL Remote]
sr_timestamp_format [SQL Remote]
string_rtruncation option [compatibility]
subscribe_by_remote option [SQL Remote]
subsume_row_locks option [database]
suppress_tds_debugging option [database]
synchronize_mirror_on_commit option [database]
tds_empty_string_is_null option [database]
temp_space_limit_check option [database]
time_format option [compatibility]
time_zone_adjustment option [database]
timestamp_format option [compatibility]
truncate_timestamp_values option [database] [MobiLink client]
truncate_with_auto_commit option [database]
tsql_hex_constant option [compatibility]
tsql_outer_joins option [compatibility]
tsql_variables option [compatibility]
updatable_statement_isolation option [database]
update_statistics option [database]
user_estimates option [database]
uuid_has_hyphens option [database]
verify_all_columns option [SQL Remote]
verify_password_function option [database]
verify_threshold option [SQL Remote]
wait_for_commit option [database]
webservice_namespace_host option [database]