Documentation
Documentation generated on: 5/14/2009 9:46:11 PM
Database objects
Database properties
| name | value |
|---|
| name | demo |
| server | demo11 |
| size |
|
| created | |
| status | |
| owner | |
| version | 11.0.1.2044 |
Server Properties
| name | value |
|---|
| blocking | On |
| blocking_timeout | 0 |
| checkpoint_time | 60 |
| conversion_error | On |
| date_format | YYYY-MM-DD |
| date_order | YMD |
| isolation_level | 0 |
| updatable_statement_isolation | 0 |
| lock_rejected_rows | Off |
| login_procedure | sp_login_environment |
| on_tsql_error | Conditional |
| precision | 30 |
| recovery_time | 2 |
| replicate_all | Off |
| row_counts | Off |
| scale | 6 |
| timestamp_format | YYYY-MM-DD HH:NN:SS.SSS |
| time_format | HH:NN:SS.SSS |
| wait_for_commit | Off |
| quoted_identifier | On |
| allow_nulls_by_default | On |
| cooperative_commits | On |
| cooperative_commit_timeout | 250 |
| delayed_commits | Off |
| delayed_commit_timeout | 500 |
| non_keywords | |
| sql_flagger_error_level | W |
| sql_flagger_warning_level | W |
| ansi_blanks | Off |
| string_rtruncation | On |
| ansinull | On |
| ansi_permissions | On |
| close_on_endtrans | On |
| tsql_variables | Off |
| chained | On |
| nearest_century | 50 |
| fire_triggers | On |
| background_priority | Off |
| login_mode | Standard |
| integrated_server_name | |
| connection_authentication | |
| java_main_userid | |
| java_location | |
| java_vm_options | |
| suppress_tds_debugging | Off |
| database_authentication | |
| default_timestamp_increment | 1 |
| escape_character | On |
| prefetch | Conditional |
| continue_after_raiserror | On |
| cis_option | 0 |
| cis_rowset_size | 50 |
| ansi_close_cursors_on_rollback | Off |
| max_statement_count | 50 |
| max_cursor_count | 50 |
| min_password_length | 0 |
| auditing | Off |
| conn_auditing | On |
| auditing_options | 4294967295 |
| tds_empty_string_is_null | Off |
| optimization_level | 9 |
| extended_join_syntax | On |
| ansi_update_constraints | Cursors |
| optimization_goal | All-rows |
| global_database_id | 2147483647 |
| max_hash_size | 10 |
| prevent_article_pkey_update | On |
| truncate_timestamp_values | Off |
| return_date_time_as_string | Off |
| first_day_of_week | 7 |
| preserve_source_format | On |
| time_zone_adjustment | 0 |
| exclude_operators | |
| user_estimates | Override-magic |
| max_plans_cached | 20 |
| sort_collation | Internal |
| pinned_cursor_percent_of_cache | 10 |
| on_charset_conversion_failure | Ignore |
| update_statistics | On |
| collect_statistics_on_dml_updates | On |
| max_recursive_iterations | 100 |
| max_query_tasks | 0 |
| for_xml_null_treatment | Omit |
| subsume_row_locks | On |
| read_past_deleted | On |
| temp_space_limit_check | On |
| force_view_creation | Off |
| dedicated_task | Off |
| debug_messages | Off |
| optimization_workload | Mixed |
| odbc_distinguish_char_and_varchar | Off |
| remote_idle_timeout | 15 |
| ansi_substring | On |
| odbc_describe_binary_as_varbinary | Off |
| rollback_on_deadlock | On |
| log_deadlocks | Off |
| webservice_namespace_host | |
| http_session_timeout | 30 |
| request_timeout | 0 |
| synchronize_mirror_on_commit | Off |
| verify_password_function | |
| allow_snapshot_isolation | Off |
| default_dbspace | |
| oem_string | |
| max_temp_space | 0 |
| secure_feature_key | |
| materialized_view_optimization | Stale |
| tsql_outer_joins | Off |
| post_login_procedure | dbo.sa_post_login_procedure |
| max_client_statements_cached | 10 |
| query_mem_timeout | -1 |
| allow_read_client_file | Off |
| allow_write_client_file | Off |
| priority | normal |
| max_priority | normal |
| verify_all_columns | Off |
| delete_old_logs | Off |
| qualify_owners | On |
| quote_all_identifiers | Off |
| replication_error | |
| replication_error_piece | |
| subscribe_by_remote | On |
| verify_threshold | 1000 |
| blob_threshold | 256 |
| compression | 6 |
| external_remote_options | Off |
| save_remote_passwords | On |
| sr_date_format | yyyy/mm/dd |
| sr_time_format | hh:nn:ss.Ssssss |
| sr_timestamp_format | hh:nn:ss.Ssssss yyyy/mm/dd |
| assume_distinct_servers | Off |
| ml_remote_id | |