Alphabetical list of options

This section lists options alphabetically.


allow_nulls_by_default option
allow_read_client_file option
allow_snapshot_isolation option
allow_write_client_file option
ansi_blanks option
ansi_close_cursors_on_rollback option
ansi_permissions option
ansi_substring option
ansi_update_constraints option
ansinull option
auditing option
auditing_options option
background_priority option [deprecated]
blob_threshold option [SQL Remote]
blocking option
blocking_others_timeout option
blocking_timeout option
chained option
checkpoint_time option
cis_option option
cis_rowset_size option
close_on_endtrans option
collect_statistics_on_dml_updates option
compression option [SQL Remote]
conn_auditing option
connection_authentication option
continue_after_raiserror option
conversion_error option
cooperative_commit_timeout option
cooperative_commits option
database_authentication
date_format option
date_order option
debug_messages option
dedicated_task option
default_dbspace option
default_timestamp_increment option
delayed_commit_timeout option
delayed_commits option
delete_old_logs option [SQL Remote]
divide_by_zero_error option
escape_character option
exclude_operators option
extended_join_syntax option
external_remote_options [SQL Remote]
fire_triggers option
first_day_of_week option
for_xml_null_treatment option
force_view_creation option
global_database_id option
http_connection_pool_basesize option
http_connection_pool_timeout option
http_session_timeout option
integrated_server_name option
isolation_level option
java_class_path option
java_location option
java_vm_options option
log_deadlocks option
login_mode option
login_procedure option
materialized_view_optimization option
max_client_statements_cached option
max_cursor_count option
max_plans_cached option
max_priority option
max_query_tasks option
max_recursive_iterations option
max_statement_count option
max_temp_space option
min_password_length option
nearest_century option
non_keywords option
odbc_describe_binary_as_varbinary
odbc_distinguish_char_and_varchar option
oem_string option
on_charset_conversion_failure option
on_tsql_error option
optimization_goal option
optimization_level option
optimization_workload option
pinned_cursor_percent_of_cache option
post_login_procedure option
precision option
prefetch option
preserve_source_format option
prevent_article_pkey_update option
priority option
progress_messages option
qualify_owners option [SQL Remote]
query_mem_timeout option
quote_all_identifiers option [SQL Remote]
quoted_identifier option
read_past_deleted option
recovery_time option
remote_idle_timeout option
replication_error option [SQL Remote]
replication_error_piece option [SQL Remote]
request_timeout option
reserved_keywords option
return_date_time_as_string option
rollback_on_deadlock
row_counts option
save_remote_passwords option [SQL Remote]
scale option
secure_feature_key
sort_collation option
sql_flagger_error_level option
sql_flagger_warning_level option
sr_date_format option [SQL Remote]
sr_time_format option [SQL Remote]
sr_timestamp_format [SQL Remote]
sr_timestamp_with_time_zone_format [SQL Remote]
st_geometry_asbinary_format option
st_geometry_astext_format option
st_geometry_asxml_format option
st_geometry_describe_type option
st_geometry_interpolation option
st_geometry_on_invalid option
string_rtruncation option
subscribe_by_remote option [SQL Remote]
subsume_row_locks option
suppress_tds_debugging option
synchronize_mirror_on_commit option
tds_empty_string_is_null option
temp_space_limit_check option
time_format option
time_zone_adjustment option
timestamp_format option
timestamp_with_time_zone_format option
truncate_timestamp_values option
tsql_outer_joins option
tsql_variables option
updatable_statement_isolation option
update_statistics option
user_estimates option
uuid_has_hyphens option
verify_all_columns option [SQL Remote]
verify_password_function option
verify_threshold option [SQL Remote]
wait_for_commit option
webservice_namespace_host option