Documentation

Supported System Functions

The following System Functions are supported for versions 1.0.0 and higher:

• fn_helpcollations
• fn_listextendedproperty

Unsupported System Functions

Babelfish provides limited support for System Functions; the following functions are unsupported:

• fn_enumcurrentprincipals
• fn_getcurrentprincipal
• fn_getrowsetidfromrowdump
• fn_isbitsetinbitmask
• fn_msdayasnumber
• fn_msgeneration_downloadonly
• fn_msget_dynamic_filter_login
• fn_msorbitmaps
• fn_msrepl_getsrvidfromdistdb
• fn_msrepl_map_resolver_clsid
• fn_mstestbit
• fn_msvector_downloadonly
• fn_msxe_read_event_stream
• fn_mapschematype
• fn_pagerescracker
• fn_physloccracker
• fn_physlocformatter
• fn_rowdumpcracker
• fn_builtin_permissions
• fn_ccolventries_80
• fn_cdc_check_parameters
• fn_cdc_decrement_lsn
• fn_cdc_get_column_ordinal
• fn_cdc_get_max_lsn
• fn_cdc_get_min_lsn
• fn_cdc_has_column_changed
• fn_cdc_hexstrtobin
• fn_cdc_increment_lsn
• fn_cdc_is_bit_set
• fn_cdc_map_lsn_to_time
• fn_cdc_map_time_to_lsn
• fn_check_object_signatures
• fn_column_store_row_groups
• fn_db_backup_file_snapshots
• fn_dblog
• fn_dblog_xtp
• fn_dbslog
• fn_dump_dblog
• fn_dump_dblog_xtp
• fn_fiscoltracked
• fn_full_dblog
• fn_get_audit_file
• fn_get_sql
• fn_getproviderstring
• fn_hadr_backup_is_preferred_replica
• fn_hadr_distributed_ag_database_replica
• fn_hadr_distributed_ag_replica
• fn_hadr_is_primary_replica
• fn_hadr_is_same_replica
• fn_helpcollations
• fn_helpdatatypemap
• fn_isrolemember
• fn_listextendedproperty
• fn_my_permissions
• fn_numberof1inbinaryafterloc
• fn_numberof1invarbinary
• fn_repl_hash_binary
• fn_repladjustcolumnmap
• fn_repldecryptver4
• fn_replformatdatetime
• fn_replgetcolidfrombitmap
• fn_replgetparsedddlcmd
• fn_replp2pversiontotranid
• fn_replreplacesinglequote
• fn_replreplacesinglequoteplusprotectstring
• fn_repluniquename
• fn_replvarbintoint
• fn_servershareddrives
• fn_sqlagent_job_history
• fn_sqlagent_jobs
• fn_sqlagent_jobsteps
• fn_sqlagent_jobsteps_logs
• fn_sqlagent_subsystems
• fn_sqlvarbasetostr
• fn_stmt_sql_handle_from_sql_stmt
• fn_trace_geteventinfo
• fn_trace_getfilterinfo
• fn_trace_getinfo
• fn_trace_gettable
• fn_translate_permissions
• fn_validate_plan_guide
• fn_varbintohexstr
• fn_varbintohexsubstring
• fn_virtualfilestats
• fn_virtualservernodes
• fn_xe_file_target_read_file
• fn_yukonsecuritymodelrequired
• dm_cryptographic_provider_algorithms
• dm_cryptographic_provider_keys
• dm_cryptographic_provider_sessions
• dm_db_database_page_allocations
• dm_db_incremental_stats_properties
• dm_db_index_operational_stats
• dm_db_index_physical_stats
• dm_db_log_info
• dm_db_log_stats
• dm_db_missing_index_columns
• dm_db_objects_disabled_on_compatibility_level_change
• dm_db_page_info
• dm_db_stats_histogram
• dm_db_stats_properties- dm_db_stats_properties_internal
• dm_enumerate_blobdirectory
• dm_exec_cached_plan_dependent_objects
• dm_exec_cursors
• dm_exec_describe_first_result_set
• dm_exec_describe_first_result_set_for_object
• dm_exec_input_buffer
• dm_exec_plan_attributes
• dm_exec_query_plan
• dm_exec_query_plan_stats
• dm_exec_query_statistics_xml
• dm_exec_sql_text
• dm_exec_text_query_plan
• dm_exec_xml_handles
• dm_fts_index_keywords
• dm_fts_index_keywords_by_document
• dm_fts_index_keywords_by_property
• dm_fts_index_keywords_position_by_document
• dm_fts_parser
• dm_io_virtual_file_stats
• dm_logconsumer_cachebufferrefs
• dm_logconsumer_privatecachebuffers
• dm_logpool_consumers
• dm_logpool_sharedcachebuffers
• dm_logpoolmgr_freepools
• dm_logpoolmgr_respoolsize
• dm_logpoolmgr_stats
• dm_os_enumerate_filesystem
• dm_os_file_exists
• dm_os_volume_stats
• dm_sql_referenced_entities
• dm_sql_referencing_entities
• geographycollectionaggregate
• geographyconvexhullaggregate
• geographyenvelopeaggregate
• geographyunionaggregate
• geometrycollectionaggregate
• geometryconvexhullaggregate
• geometryenvelopeaggregate
• geometryunionaggregate
• ormask
• fn_syspolicy_is_automation_enabled