Database reference - demo

Database overview

Documentation

Documentation generated on: 5/14/2009 9:46:11 PM

Database objects

typecount
tables43
views6
indexes23
procedures49
functions4
types18
triggers0
defaults0
rules0

Database properties

namevalue
namedemo
serverdemo11
size 
created
status
owner
version11.0.1.2044

Server Properties

namevalue
blockingOn
blocking_timeout0
checkpoint_time60
conversion_errorOn
date_formatYYYY-MM-DD
date_orderYMD
isolation_level0
updatable_statement_isolation0
lock_rejected_rowsOff
login_proceduresp_login_environment
on_tsql_errorConditional
precision30
recovery_time2
replicate_allOff
row_countsOff
scale6
timestamp_formatYYYY-MM-DD HH:NN:SS.SSS
time_formatHH:NN:SS.SSS
wait_for_commitOff
quoted_identifierOn
allow_nulls_by_defaultOn
cooperative_commitsOn
cooperative_commit_timeout250
delayed_commitsOff
delayed_commit_timeout500
non_keywords
sql_flagger_error_levelW
sql_flagger_warning_levelW
ansi_blanksOff
string_rtruncationOn
ansinullOn
ansi_permissionsOn
close_on_endtransOn
tsql_variablesOff
chainedOn
nearest_century50
fire_triggersOn
background_priorityOff
login_modeStandard
integrated_server_name
connection_authentication
java_main_userid
java_location
java_vm_options
suppress_tds_debuggingOff
database_authentication
default_timestamp_increment1
escape_characterOn
prefetchConditional
continue_after_raiserrorOn
cis_option0
cis_rowset_size50
ansi_close_cursors_on_rollbackOff
max_statement_count50
max_cursor_count50
min_password_length0
auditingOff
conn_auditingOn
auditing_options4294967295
tds_empty_string_is_nullOff
optimization_level9
extended_join_syntaxOn
ansi_update_constraintsCursors
optimization_goalAll-rows
global_database_id2147483647
max_hash_size10
prevent_article_pkey_updateOn
truncate_timestamp_valuesOff
return_date_time_as_stringOff
first_day_of_week7
preserve_source_formatOn
time_zone_adjustment0
exclude_operators
user_estimatesOverride-magic
max_plans_cached20
sort_collationInternal
pinned_cursor_percent_of_cache10
on_charset_conversion_failureIgnore
update_statisticsOn
collect_statistics_on_dml_updatesOn
max_recursive_iterations100
max_query_tasks0
for_xml_null_treatmentOmit
subsume_row_locksOn
read_past_deletedOn
temp_space_limit_checkOn
force_view_creationOff
dedicated_taskOff
debug_messagesOff
optimization_workloadMixed
odbc_distinguish_char_and_varcharOff
remote_idle_timeout15
ansi_substringOn
odbc_describe_binary_as_varbinaryOff
rollback_on_deadlockOn
log_deadlocksOff
webservice_namespace_host
http_session_timeout30
request_timeout0
synchronize_mirror_on_commitOff
verify_password_function
allow_snapshot_isolationOff
default_dbspace
oem_string
max_temp_space0
secure_feature_key
materialized_view_optimizationStale
tsql_outer_joinsOff
post_login_proceduredbo.sa_post_login_procedure
max_client_statements_cached10
query_mem_timeout-1
allow_read_client_fileOff
allow_write_client_fileOff
prioritynormal
max_prioritynormal
verify_all_columnsOff
delete_old_logsOff
qualify_ownersOn
quote_all_identifiersOff
replication_error
replication_error_piece
subscribe_by_remoteOn
verify_threshold1000
blob_threshold256
compression6
external_remote_optionsOff
save_remote_passwordsOn
sr_date_formatyyyy/mm/dd
sr_time_formathh:nn:ss.Ssssss
sr_timestamp_formathh:nn:ss.Ssssss yyyy/mm/dd
assume_distinct_serversOff
ml_remote_id



Documentation generated by SqlSpec