Hi Friends,

In this post I want to show you how you can find out SQL Server 2014 New System Objects, yourself!

From SQL Server 2014 VM (or a physical box), add a Linked Server connection to a SQL Server 2012 VM (or a physical box)

And execute the following script:

SELECT a.NAME sql14_objname
    ,a.xtype sql14_objtype
    ,b.NAME
FROM sys.sysobjects a
LEFT JOIN [WIN2K8R2\SQL2012SP1].master.sys.sysobjects b ON a.NAME = b.NAME
WHERE b.NAME IS NULL
ORDER BY sql14_objtype

And you get the output as follows:

sql14_objnamesql14_objtype
fn_hadr_is_primary_replicaFNNULL
fn_column_store_row_groupsIFNULL
fn_dblog_xtpIFNULL
fn_dump_dblog_xtpIFNULL
dm_db_stats_properties_internalIFNULL
sqlagent_job_historyITNULL
sqlagent_jobsITNULL
sqlagent_jobstepsITNULL
sqlagent_jobsteps_logsITNULL
sp_cci_tuple_moverPNULL
sp_sqlagent_add_jobPNULL
sp_sqlagent_add_jobstepPNULL
sp_sqlagent_delete_jobPNULL
sp_sqlagent_help_jobstepPNULL
sp_sqlagent_log_job_historyPNULL
sp_sqlagent_start_jobPNULL
sp_sqlagent_stop_jobPNULL
sp_sqlagent_verify_database_contextPNULL
sp_sqlagent_write_jobstep_logPNULL
sp_xtp_bind_db_resource_poolPNULL
sp_xtp_checkpoint_force_garbage_collectionPNULL
sp_xtp_control_proc_exec_statsPNULL
sp_xtp_control_query_exec_statsPNULL
sp_xtp_merge_checkpoint_filesPNULL
sp_xtp_unbind_db_resource_poolPNULL
syscsrowgroupsSNULL
sysextfileformatsSNULL
sysextsourcesSNULL
sysexttablesSNULL
fn_sqlagent_job_historyTFNULL
fn_sqlagent_jobsTFNULL
fn_sqlagent_jobstepsTFNULL
fn_sqlagent_jobsteps_logsTFNULL
fn_sqlagent_subsystemsTFNULL
hash_indexesVNULL
dm_db_xtp_checkpoint_filesVNULL
dm_db_xtp_checkpoint_statsVNULL
dm_db_xtp_gc_cycle_statsVNULL
dm_db_xtp_hash_index_statsVNULL
dm_db_xtp_index_statsVNULL
dm_db_xtp_memory_consumersVNULL
dm_db_xtp_merge_requestsVNULL
dm_db_xtp_nonclustered_index_statsVNULL
dm_db_xtp_object_statsVNULL
dm_db_xtp_table_memory_statsVNULL
dm_db_xtp_transactionsVNULL
dm_exec_query_profilesVNULL
dm_io_cluster_valid_path_namesVNULL
dm_os_buffer_pool_extension_configurationVNULL
dm_resource_governor_resource_pool_volumesVNULL
dm_xtp_gc_queue_statsVNULL
dm_xtp_gc_statsVNULL
dm_xtp_system_memory_consumersVNULL
dm_xtp_threadsVNULL
dm_xtp_transaction_recent_rowsVNULL
dm_xtp_transaction_statsVNULL
column_store_row_groupsVNULL
sp_flush_logXNULL

 

The object types are as follows:

FN = Scalar Function

IF = In-line Table Function

IT = Internal Table

P = Stored Procedure

S = System Table

TF = Table Function

V = View

X = Extended Stored Procedure

Want to watch this in action? Watch here!