Home Microsoft SQL Server   - System tables   - Procedure   - Views   - DMV   - Functions DigiMailing Contact

The name of the object you are looking for Questions Feel free to contact. Email answer to Question Type this code System views in the mssqlsystemresource database MSSQL 2008 allocation_units all_columns all_extended_procedures all_objects all_parameters all_sql_modules all_views assemblies assembly_files assembly_modules assembly_references assembly_types asymmetric_keys audits$ backup_devices certificates change_tracking_databases change_tracking_tables CHECK_CONSTRAINTS check_constraints COLUMNS columns COLUMN_DOMAIN_USAGE COLUMN_PRIVILEGES column_type_usages column_xml_schema_collection_usages computed_columns configurations CONSTRAINT_COLUMN_USAGE CONSTRAINT_TABLE_USAGE conversation_endpoints conversation_endpoints$ conversation_groups conversation_groups$ conversation_priorities credentials cryptographic_providers crypt_properties databases databases database_audit_specifications database_audit_specification_details database_files database_mirroring database_mirroring_endpoints database_mirroring_witnesses database_permissions database_principals database_principal_aliases database_recovery_status database_role_members data_spaces default_constraints destination_data_spaces dm_audit_actions dm_audit_class_type_map dm_broker_activated_tasks dm_broker_connections dm_broker_forwarded_messages dm_broker_queue_monitors dm_cdc_errors dm_cdc_log_scan_sessions dm_clr_appdomains dm_clr_loaded_assemblies dm_clr_properties dm_clr_tasks dm_cryptographic_provider_properties dm_database_encryption_keys dm_db_file_space_usage dm_db_index_usage_stats dm_db_mirroring_auto_page_repair dm_db_mirroring_connections dm_db_mirroring_past_actions dm_db_missing_index_details dm_db_missing_index_groups dm_db_missing_index_group_stats dm_db_partition_stats dm_db_persisted_sku_features dm_db_script_level dm_db_session_space_usage dm_db_task_space_usage dm_exec_background_job_queue dm_exec_background_job_queue_stats dm_exec_cached_plans dm_exec_connections dm_exec_procedure_stats dm_exec_query_memory_grants dm_exec_query_optimizer_info dm_exec_query_resource_semaphores dm_exec_query_stats dm_exec_query_transformation_stats dm_exec_requests dm_exec_sessions dm_exec_sql_text dm_exec_trigger_stats dm_filestream_file_io_handles dm_filestream_file_io_requests dm_fts_active_catalogs dm_fts_fdhosts dm_fts_index_population dm_fts_memory_buffers dm_fts_memory_pools dm_fts_outstanding_batches dm_fts_population_ranges dm_io_backup_tapes dm_io_cluster_shared_drives dm_io_pending_io_requests dm_os_buffer_descriptors dm_os_child_instances dm_os_cluster_nodes dm_os_dispatchers dm_os_dispatcher_pools dm_os_hosts dm_os_latch_stats dm_os_loaded_modules dm_os_memory_allocations dm_os_memory_brokers dm_os_memory_cache_clock_hands dm_os_memory_cache_counters dm_os_memory_cache_entries dm_os_memory_cache_hash_tables dm_os_memory_clerks dm_os_memory_nodes dm_os_memory_node_access_stats dm_os_memory_objects dm_os_memory_pools dm_os_nodes dm_os_performance_counters dm_os_process_memory dm_os_ring_buffers dm_os_schedulers dm_os_spinlock_stats dm_os_stacks dm_os_sublatches dm_os_sys_info dm_os_sys_memory dm_os_tasks dm_os_threads dm_os_virtual_address_dump dm_os_waiting_tasks dm_os_wait_stats dm_os_workers dm_os_worker_local_storage dm_qn_subscriptions dm_repl_articles dm_repl_schemas dm_repl_tranhash dm_repl_traninfo dm_resource_governor_configuration dm_resource_governor_resource_pools dm_resource_governor_workload_groups dm_server_audit_status dm_tran_active_snapshot_database_transactions dm_tran_active_transactions dm_tran_commit_table dm_tran_current_snapshot dm_tran_current_transaction dm_tran_database_transactions dm_tran_locks dm_tran_session_transactions dm_tran_top_version_generators dm_tran_transactions_snapshot dm_tran_version_store dm_xe_map_values dm_xe_objects dm_xe_object_columns dm_xe_packages dm_xe_sessions dm_xe_session_events dm_xe_session_event_actions dm_xe_session_object_columns dm_xe_session_targets DOMAINS DOMAIN_CONSTRAINTS endpoints endpoint_webmethods events event_notifications event_notification_event_types extended_procedures extended_properties filegroups foreign_keys foreign_key_columns fulltext_catalogs fulltext_document_types fulltext_indexes fulltext_index_catalog_usages fulltext_index_columns fulltext_index_fragments fulltext_languages fulltext_stoplists fulltext_stopwords fulltext_system_stopwords fulltext_thesaurus_files function_order_columns http_endpoints identity_columns indexes indexes$ index_columns index_counts internal_tables KEY_COLUMN_USAGE key_constraints key_encryptions linked_logins login_token master_files master_files$ master_key_passwords messages messages$ message_type_xml_schema_collection_usages module_assembly_usages numbered_procedures numbered_procedures$ numbered_procedure_parameters obd_state objects objects$ openkeys PARAMETERS parameters$ parameter_type_usages parameter_xml_schema_collection_usages partitions partition_functions partition_parameters partition_range_values partition_schemes plan_guides procedures REFERENTIAL_CONSTRAINTS remote_logins remote_service_bindings resource_governor_configuration resource_governor_resource_pools resource_governor_workload_groups routes ROUTINES ROUTINE_COLUMNS ROUTINE_COLUMNS sac_state schemas SCHEMATA securable_classes servers server_assembly_modules server_audits server_audit_specifications server_audit_specification_details server_events server_event_notifications server_event_sessions server_event_session_actions server_event_session_events server_event_session_fields server_event_session_targets server_file_audits server_permissions server_principals server_principal_credentials server_role_members server_sql_modules server_triggers server_trigger_events services services$ service_broker_endpoints service_contracts service_contracts$ service_contract_message_usages service_contract_usages service_message_types service_message_types$ service_queues service_queue_usages soap_endpoints spatial_indexes spatial_index_tessellations spatial_reference_systems spt_all_procedures spt_check_constbytable_rowset spt_columns_odbc_view spt_columns_view spt_columns_view_managed spt_column_privileges_owner_view spt_column_privileges_set_view spt_datatype_info_view spt_indexcolumns_view_managed spt_indexes_view spt_indexes_view_100 spt_indexes_view_managed spt_parameters_numbered_parameters spt_parameters_system spt_parameters_user spt_primary_keys_view spt_procedures_system spt_procedures_user spt_procedure_params_return_values_view spt_procedure_params_view spt_provider_types_view spt_sparse_columns_view spt_sproc_columns_odbc_view spt_sproc_columns_return_values_odbc_view spt_tablecollations_view spt_tables_info_view spt_tables_view spt_table_privileges_view spt_table_types_view spt_table_type_columns_view spt_table_type_primary_keys_view spt_xml_schema_view sql_dependencies sql_expression_dependencies sql_expression_dependencies$ sql_logins sql_modules stats stats_columns symmetric_keys synonyms sysaltfiles syscacheobjects syscharsets syscolumns syscomments sysconfigures sysconstraints syscurconfigs syscursorcolumns syscursorrefs syscursors syscursortables sysdatabases sysdepends sysdevices sysfilegroups sysfiles sysforeignkeys sysfulltextcatalogs sysindexes sysindexkeys syslanguages syslockinfo syslogins sysmembers sysmessages sysobjects sysoledbusers sysopentapes sysperfinfo syspermissions sysprocesses sysprocesses_ex sysprotects sysreferences sysremotelogins sysservers system_columns system_components_surface_area_configuration system_internals_allocation_units system_internals_partitions system_internals_partition_columns system_objects system_objects$ system_parameters system_parameters$ system_sql_modules system_views systypes sysusers TABLES tables TABLE_CONSTRAINTS TABLE_PRIVILEGES table_types tcp_endpoints traces trace_categories trace_columns trace_events trace_event_bindings trace_subclass_values transmission_queue triggers trigger_events trigger_event_types types type_assembly_usages user_token via_endpoints VIEWS VIEW_COLUMN_USAGE VIEW_TABLE_USAGE xml_indexes xml_schema_attributes xml_schema_collections xml_schema_components xml_schema_component_placements xml_schema_elements xml_schema_facets xml_schema_model_groups xml_schema_namespaces xml_schema_types xml_schema_wildcards xml_schema_wildcard_namespaces

See also Nieuws Create all your missing indexes Converting datetime field Start MSSQL Server Profiler at time Replicating MSSQL Server views Exploring Microsoft Sharepoint The OLE DB provider "SQLNCLI10" for linked server indicates. Mobile solar charger Oracle to SQL Server replication Cannot insert the value NULL into column Undocumented Microsoft SQL Server 2008 VMware Zoekmachine optimalisatie SQL Servers hidden objects FckEditor Flash in Ajax De hype die AJAX heet Barcode scannen MySQL; Gratis, makkelijk en snel! PHP sIFR; de combinatie tussen HTML en Flash