October 7, 2018 at 8:41 am
Just ran through the list of sys.all_objects, here is the difference
😎
New in 2019
dm_column_encryption_enclave
dm_column_encryption_enclave_operation_stats
dm_db_missing_index_group_stats_query
dm_db_objects_disabled_on_compatibility_level_change
dm_db_page_info
dm_distributed_exchange_stats
dm_hadr_ag_threads
dm_hadr_db_threads
dm_os_job_object
dm_tran_aborted_transactions
edge_constraint_clauses
edge_constraints
external_libraries_installed
fn_dbslog
fn_getproviderstring
fn_MSrepl_getsrvidfromdistdb
fn_PageResCracker
sensitivity_classifications
sp_add_feature_restriction
sp_autoindex_cancel_dta
sp_autoindex_invoke_dta
sp_change_repl_serverport
sp_cloud_update_blob_tier
sp_configure_automatic_tuning
sp_diagnostic_showplan_log_dbid
sp_drop_feature_restriction
sp_execute_remote
sp_force_slog_truncation
sp_getdistributorplatform
sp_internal_alter_nt_job_limits
sp_MSget_server_portinfo
sp_MSrepl_monitor_job_at_failover
sp_MSrepl_reinit_jobsync_table
sp_MSset_repl_serveroptions
sp_persistent_version_cleanup
sp_persistent_version_store
sp_rbpex_exec_cmd
sp_replmonitorgetoriginalpublisher
sp_restore_filelistonly
sp_set_distributed_query_context
sp_set_session_resource_group
sp_showinitialmemo_xml
sp_sqljdbc_xa_install
sp_sqljdbc_xa_uninstall
sp_xa_commit
sp_xa_end
sp_xa_forget
sp_xa_forget_ex
sp_xa_init
sp_xa_init_ex
sp_xa_prepare
sp_xa_prepare_ex
sp_xa_recover
sp_xa_rollback
sp_xa_rollback_ex
sp_xa_start
xp_copy_file
xp_copy_files
xp_delete_files
Discarded in 2019dm_db_objects_disabled_on_compatibility_level_change Still works although it does not show up in the object list
sp_query_tuning_ignore_query
sp_query_tuning_unignore_query
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply