December 6, 2012

Microsoft SQL System View Version Map

See all Groups here of look in the table under here:
SystemView Sql 2005 Sql 2008 Sql 2008 R2 Sql 2012 Difference Info
sys.all_columns More Info
sys.all_objects  
sys.all_parameters  
sys.all_sql_modules More Info
sys.all_views  
sys.allocation_units  
sys.assemblies More Info
sys.assembly_files  
sys.assembly_modules  
sys.assembly_references  
sys.assembly_types More Info
sys.asymmetric_keys More Info
sys.availability_databases_cluster       More Info
sys.availability_group_listener_ip_addresses       More Info
sys.availability_group_listeners       More Info
sys.availability_groups       More Info
sys.availability_groups_cluster       More Info
sys.availability_read_only_routing_lists       More Info
sys.availability_replicas       More Info
sys.backup_devices  
sys.certificates More Info
sys.change_tracking_databases   More Info
sys.change_tracking_tables   More Info
sys.check_constraints  
sys.column_xml_schema_collection_usages  
sys.columns More Info
sys.computed_columns More Info
sys.conversation_endpoints More Info
sys.conversation_groups  
sys.conversation_priorities   More Info
sys.credentials More Info
sys.crypt_properties  
sys.cryptographic_providers   More Info
sys.data_spaces More Info
sys.database_audit_specification_details   More Info
sys.database_audit_specifications   More Info
sys.database_files  
sys.database_mirroring More Info
sys.database_mirroring_endpoints  
sys.database_permissions  
sys.database_principals  
sys.database_recovery_status  
sys.database_role_members  
sys.databases More Info
sys.default_constraints  
sys.destination_data_spaces  
sys.dm_clr_appdomains More Info
sys.dm_clr_loaded_assemblies  
sys.dm_clr_properties  
sys.dm_clr_tasks  
sys.dm_db_file_space_usage More Info
sys.dm_db_partition_stats  
sys.dm_db_session_space_usage  
sys.dm_db_task_space_usage  
sys.dm_exec_background_job_queue  
sys.dm_exec_background_job_queue_stats  
sys.dm_exec_cached_plan_dependent_objects  
sys.dm_exec_cached_plans More Info
sys.dm_exec_connections  
sys.dm_exec_cursors  
sys.dm_exec_plan_attributes More Info
sys.dm_exec_query_memory_grants More Info
sys.dm_exec_query_optimizer_info  
sys.dm_exec_query_plan  
sys.dm_exec_query_resource_semaphores More Info
sys.dm_exec_query_stats More Info
sys.dm_exec_requests More Info
sys.dm_exec_sessions More Info
sys.dm_exec_sql_text  
sys.dm_exec_text_query_plan  
sys.dm_exec_xml_handles  
sys.dm_io_backup_tapes  
sys.dm_io_cluster_shared_drives  
sys.dm_io_pending_io_requests  
sys.dm_io_virtual_file_stats  
sys.dm_os_buffer_descriptors More Info
sys.dm_os_child_instances  
sys.dm_os_cluster_nodes More Info
sys.dm_os_hosts  
sys.dm_os_latch_stats  
sys.dm_os_loaded_modules  
sys.dm_os_memory_cache_clock_hands  
sys.dm_os_memory_cache_counters More Info
sys.dm_os_memory_cache_entries More Info
sys.dm_os_memory_cache_hash_tables  
sys.dm_os_memory_clerks More Info
sys.dm_os_memory_objects  
sys.dm_os_memory_pools  
sys.dm_os_performance_counters  
sys.dm_os_schedulers More Info
sys.dm_os_stacks  
sys.dm_os_sys_info More Info
sys.dm_os_tasks More Info
sys.dm_os_threads More Info
sys.dm_os_virtual_address_dump  
sys.dm_os_wait_stats  
sys.dm_os_waiting_tasks  
sys.dm_os_workers More Info
sys.dm_repl_articles  
sys.dm_repl_schemas  
sys.dm_repl_tranhash  
sys.dm_repl_traninfo More Info
sys.dm_tran_active_snapshot_database_transactions  
sys.dm_tran_active_transactions More Info
sys.dm_tran_current_snapshot  
sys.dm_tran_current_transaction  
sys.dm_tran_database_transactions  
sys.dm_tran_locks  
sys.dm_tran_session_transactions  
sys.dm_tran_top_version_generators  
sys.dm_tran_transactions_snapshot  
sys.dm_tran_version_store  
sys.endpoint_webmethods  
sys.endpoints  
sys.event_notifications  
sys.events More Info
sys.extended_procedures  
sys.extended_properties  
sys.filegroups More Info
sys.foreign_key_columns  
sys.foreign_keys  
sys.fulltext_catalogs More Info
sys.fulltext_document_types  
sys.fulltext_index_catalog_usages  
sys.fulltext_index_columns More Info
sys.fulltext_index_fragments   More Info
sys.fulltext_indexes More Info
sys.fulltext_languages  
sys.fulltext_semantic_language_statistics_database       More Info
sys.fulltext_semantic_languages       More Info
sys.fulltext_stoplists   More Info
sys.fulltext_stopwords   More Info
sys.fulltext_system_stopwords   More Info
sys.function_order_columns   More Info
sys.functions  
sys.http_endpoints  
sys.identity_columns More Info
sys.index_columns More Info
sys.indexes More Info
sys.internal_tables  
sys.key_constraints  
sys.key_encryptions  
sys.linked_logins  
sys.master_files  
sys.master_key_passwords  
sys.message_type_xml_schema_collection_usages  
sys.numbered_procedure_parameters  
sys.numbered_procedures  
sys.objects  
sys.parameter_xml_schema_collection_usages  
sys.parameters More Info
sys.partition_parameters More Info
sys.partition_range_values  
sys.partition_schemes More Info
sys.partitions More Info
sys.procedures  
sys.registered_search_properties       More Info
sys.registered_search_property_lists       More Info
sys.remote_logins  
sys.remote_service_bindings  
sys.routes  
sys.rules  
sys.schemas  
sys.server_audit_specification_details   More Info
sys.server_audit_specifications   More Info
sys.server_audits   More Info
sys.server_event_session_actions   More Info
sys.server_event_session_events   More Info
sys.server_event_session_fields   More Info
sys.server_event_session_targets   More Info
sys.server_event_sessions   More Info
sys.server_file_audits   More Info
sys.server_permissions  
sys.server_principals More Info
sys.server_role_members  
sys.servers More Info
sys.service_contract_message_usages  
sys.service_contract_usages  
sys.service_contracts  
sys.service_message_types  
sys.service_queue_usages  
sys.service_queues More Info
sys.services  
sys.soap_endpoints  
sys.spatial_index_tessellations   More Info
sys.spatial_indexes   More Info
sys.sql_dependencies  
sys.sql_expression_dependencies   More Info
sys.sql_logins More Info
sys.sql_modules More Info
sys.stats More Info
sys.stats_columns  
sys.symmetric_keys More Info
sys.synonyms  
sys.sysalt_files  
sys.syscache_objects  
sys.syscharsets  
sys.syscolumns  
sys.syscomments  
sys.sysconfigures  
sys.sysconstraints  
sys.syscur_configs  
sys.sysdatabases  
sys.sysdepends More Info
sys.sysdevices  
sys.sysfile_groups  
sys.sysfiles  
sys.sysforeign_keys  
sys.sysfulltext_catalogs  
sys.sysindexes More Info
sys.sysindexkeys  
sys.syslanguages  
sys.syslock_info  
sys.syslogins  
sys.sysmembers  
sys.sysmessages  
sys.sysobjects  
sys.sysoledbusers  
sys.sysperf_info  
sys.syspermissions  
sys.sysprocesses  
sys.sysprotects  
sys.sysreferences  
sys.sysremote_logins  
sys.sysservers More Info
sys.system_columns More Info
sys.system_components_surface_area_configuration  
sys.system_functions  
sys.system_objects  
sys.system_parameters  
sys.system_stored_procedures  
sys.system_views  
sys.systypes More Info
sys.sysusers  
sys.table_types   More Info
sys.tables More Info
sys.tcp_endpoints  
sys.transmission_queue More Info
sys.trigger_event_types   More Info
sys.trigger_events More Info
sys.triggers  
sys.types More Info
sys.via_endpoints  
sys.views  
sys.xml_indexes More Info
sys.xml_schema_attributes  
sys.xml_schema_collections  
sys.xml_schema_component_placements  
sys.xml_schema_components  
sys.xml_schema_elements  
sys.xml_schema_facets  
sys.xml_schema_model_groups  
sys.xml_schema_namespaces  
sys.xml_schema_types  
sys.xml_schema_wildcard_namespaces  
sys.xml_schema_wildcards  
syscollector_collection_items   More Info
syscollector_collection_sets   More Info
syscollector_collector_types   More Info
syscollector_config_store   More Info
syscollector_execution_log   More Info
syscollector_execution_log_full   More Info
syscollector_execution_stats   More Info
sysmail_allitems  
sysmail_event_log  
sysmail_faileditems  
sysmail_mailattachments  
sysmail_sentitems  
sysmail_unsentitems  


Following groups has been mapped:

No comments:

Post a Comment

Total Pageviews