Link Search Menu Expand Document Documentation Menu

Supported Stored Procedures

The following lists detail the functionality implemented for each version of Babelfish (and subsequent releases).

The following System-provided Stored Procedures are supported for versions 2.1.0 and higher:

  • sp_sproc_columns
  • sp_sproc_columns_100
  • sp_helprole
  • sp_helprolemember

The following System-provided Stored Procedures are supported for versions 1.2.0 and higher:

  • sp_table_privileges
  • sp_column_privileges
  • sp_special_columns
  • sp_fkeys
  • sp_pkeys
  • sp_stored_procedures
  • xp_qv
  • sp_describe_undeclared_parameters
  • sp_helpuser

The following System-provided Stored Procedures are supported for versions 1.0.0 and higher:

  • sp_helpdb
  • sp_getapplock
  • sp_releaseapplock
  • sp_columns
  • sp_columns_100
  • sp_columns_managed
  • sp_cursor_list
  • sp_datatype_info
  • sp_datatype_info_100
  • sp_describe_CURSOR
  • sp_DESCRIBE_FIRST_RESULT_SET
  • sp_DESCRIBE_UNDECLARED_PARAMETERS
  • sp_executesql
  • sp_oledb_ro_usrname
  • sp_prepare
  • sp_tablecollations_100
  • sp_tables
  • sp_unprepare
  • sp_statistics
  • sp_statistics_100
  • sp_updatestats
  • sp_pkeys
  • sp_databases
  • sp_cursor
  • sp_cursoropen
  • sp_cursorprepare
  • sp_cursorexecute
  • sp_cursorprepexec
  • sp_cursorunprepare
  • sp_cursorfetch
  • sp_cursoroption
  • sp_cursorclose |

Unsupported Stored Procedures

Babelfish provides limited support for SQL Server stored procedures. In the following list of unsupported stored procedures, % represents any combination of characters:

  • sp_add%
  • sp_adjustpublisheridentityrange
  • sp_agent_%
  • sp_alter_nt_job_mem_configs
  • sp_altermessage
  • sp_apply_job_to_targets
  • sp_approlepassword
  • sp_article%
  • sp_assembl%
  • sp_attach%
  • sp_audit_write
  • sp_autoadmin_%
  • sp_autoindex%
  • sp_autostats
  • sp_availability_group_command_internal
  • sp_backup_%
  • sp_bcp_dbcmptlevel
  • sp_begin_parallel_nested_tran
  • sp_bindefault
  • sp_bindrule
  • sp_bindsession
  • sp_browsemergesnapshotfolder
  • sp_browsereplcmds
  • sp_browsesnapshotfolder
  • sp_build_histogram
  • sp_can_tlog_be_applied
  • sp_catalogs%
  • sp_cdc_%
  • sp_certify_removable
  • sp_change%
  • sp_check%
  • sp_clean%
  • sp_clear_dbmaintplan_by_db
  • sp_cloud_update_blob_tier
  • sp_column%
  • sp_commit_parallel_nested_tran
  • sp_configure%
  • sp_constr_col%
  • sp_control_dbmasterkey_password
  • sp_control_plan_guide
  • sp_convert_jobid_to_char
  • sp_copymergesnapshot
  • sp_copysnapshot
  • sp_copysubscription
  • sp_create_file_statistics
  • sp_create_job
  • sp_create_log_shipping_monitor_account
  • sp_create_plan_guide%
  • sp_create_removable
  • sp_createmergepalrole
  • sp_createorphan
  • sp_createstats
  • sp_createtranpalrole
  • sp_cursor%
  • sp_cycle_agent_errorlog
  • sp_cycle_errorlog
  • sp_databases
  • sp_datatype_info%
  • sp_db_ebcdic277_2
  • sp_db_increased_partitions
  • sp_db_selective_xml_index
  • sp_db_vardecimal_storage_format
  • sp_dbcmptlevel
  • sp_dbfixedrolepermission
  • sp_dbmmonitor%
  • sp_dbremove
  • sp_ddopen
  • sp_defaultdb
  • sp_defaultlanguage
  • sp_delete%
  • sp_denylogin
  • sp_depends
  • sp_describe_%
  • sp_detach_db
  • sp_detach_schedule
  • sp_diagnostic_showplan_log_dbid
  • sp_disableagentoffload
  • sp_distcounters
  • sp_do_backup
  • sp_downloaded_row_limiter
  • sp_drop%
  • sp_dsninfo
  • sp_enable_heterogeneous_subscription
  • sp_enable_sql_debug
  • sp_enableagentoffload
  • sp_enclave_send_keys
  • sp_enlist_tsx
  • sp_enum%
  • sp_enum_login_for_proxy
  • sp_enum_proxy_for_subsystem
  • sp_enum_sqlagent_subsystems
  • sp_enum_sqlagent_subsystems_internal
  • sp_estimate_data_compression_savings
  • sp_estimated_rowsize_reduction_for_vardecimal
  • sp_execute
  • sp_execute_external_script
  • sp_execute_remote
  • sp_expired_subscription_cleanup
  • sp_externalmailqueuelistener
  • sp_fido_%
  • sp_filestream%
  • sp_firstonly_bitmap
  • sp_fkeys
  • sp_flush%
  • sp_force_slog_truncation
  • sp_foreign%
  • sp_fulltext_%
  • sp_generate_agent_parameter
  • sp_generate_server_description
  • sp_generate_target_server_job_assignment_sql
  • sp_generatefilters
  • sp_get_backup_diagnostics
  • sp_get_chunked_jobstep_params
  • sp_get_composite_job_info
  • sp_get_database_scoped_credential
  • sp_get_distributor
  • sp_get_encryption_option
  • sp_get_file_statistics_hash
  • sp_get_job_alerts
  • sp_get_job_status_mergesubscription_agent
  • sp_get_jobstep_db_username
  • sp_get_log_shipping_monitor_info
  • sp_get_mergepublishedarticleproperties
  • sp_get_message_description
  • sp_get_oracle_publisher_metadata
  • sp_get_proxy_properties
  • sp_get_query_template
  • sp_get_redirected_publisher
  • sp_get_schedule_description
  • sp_get_sqlagent_properties
  • sp_get_striping_option
  • sp_get_traceflag_status_internal
  • sp_getagentparameterlist
  • sp_getapplock
  • sp_getattachmentdata
  • sp_getbindtoken
  • sp_getdefaultdatatypemapping
  • sp_getmergedeletetype
  • sp_getprocessorusage
  • sp_getpublisherlink
  • sp_getqueuedarticlesynctraninfo
  • sp_getqueuedrows
  • sp_getschemalock
  • sp_getsqlqueueversion
  • sp_getsubscription_status_hsnapshot
  • sp_getsubscriptiondtspackagename
  • sp_gettopologyinfo
  • sp_getvolumefreespace
  • sp_grant_login_to_proxy
  • sp_grant_proxy_to_subsystem
  • sp_grant_publication_access
  • sp_grantdbaccess
  • sp_grantlogin
  • sp_help%
  • sp_http_%
  • sp_identitycolumnforreplication
  • sp_ih%
  • sp_index%
  • sp_internal_alter_nt_job_limits
  • sp_invalidate_textptr
  • sp_is_makegeneration_needed
  • sp_is_sqlagent_starting
  • sp_isprohibited
  • sp_ivindexhasnullcols
  • sp_jobhistory_row_limiter
  • sp_kill_filestream_non_transacted_handles
  • sp_kill_oldest_transaction_on_secondary
  • sp_lightweightmergemetadataretentioncleanup
  • sp_link_publication
  • sp_linkedservers%
  • sp_lock
  • sp_log_shipping_%
  • sp_logshippinginstallmetadata
  • sp_lookupcustomresolver
  • sp_mailitemresultsets
  • sp_maintplan_%
  • sp_manage_jobs_by_login
  • sp_mapdown_bitmap
  • sp_markpendingschemachange
  • sp_marksubscriptionvalidation
  • sp_memory_optimized_cs_migration
  • sp_merge%
  • sp_migrate_user_to_contained
  • sp_monitor
  • sp_ms%
  • sp_multi_server_job_summary
  • sp_new_parallel_nested_tran_id
  • sp_notify_operator
  • sp_oa%
  • sp_objectfilegroup
  • sp_oledb%
  • sp_orbitmap
  • sp_password
  • sp_peerconflictdetection_tableaug
  • sp_pkeys
  • sp_polybase_%
  • sp_post_msx_operation
  • sp_postagentinfo
  • sp_posttracertoken
  • sp_prepare
  • sp_prepexec
  • sp_prepexecrpc
  • sp_primary%
  • sp_procedure%
  • sp_process_DialogTimer
  • sp_processlogshipping%
  • sp_processresponse
  • sp_procoption
  • sp_prop_oledb_provider
  • sp_provider_types%
  • sp_publication%
  • sp_publish%
  • sp_purge_jobhistory
  • sp_query_store_%
  • sp_rbpex_exec_cmd
  • sp_rda_%
  • sp_read_settings
  • sp_readerrorlog
  • sp_readrequest
  • sp_reassign_proxy
  • sp_recompile
  • sp_redirect_publisher
  • sp_refresh%
  • sp_register%
  • sp_reinit%
  • sp_releaseapplock
  • sp_releaseschemalock
  • sp_remote_data_archive_event
  • sp_remoteoption
  • sp_remove%
  • sp_rename
  • sp_renamedb
  • sp_repl%
  • sp_requestpeer%
  • sp_reserve_http_namespace
  • sp_reset_connection
  • sp_reset_session_context
  • sp_resetsnapshotdeliveryprogress
  • sp_resetstatus
  • sp_resign_database
  • sp_resolve_logins
  • sp_restoredbreplication
  • sp_restoremergeidentityrange
  • sp_resync%
  • sp_revoke%
  • sp_rollback_parallel_nested_tran
  • sp_runmailquery
  • sp_schemafilter
  • sp_schemata_rowset
  • sp_script%
  • sp_sem_add_message
  • sp_sem_drop_message
  • sp_send_dbmail
  • sp_sendmailmessage
  • sp_sendmailqueues
  • sp_sequence_get_range
  • sp_server_diagnostics
  • sp_server_info
  • sp_serveroption
  • sp_set_db_backup
  • sp_set_distributed_query_context
  • sp_set_instance_backup
  • sp_set_local_time
  • sp_set_parameter
  • sp_set_session_context
  • sp_set_session_resource_group
  • sp_set_sqlagent_properties
  • sp_setapprole
  • sp_setautosapasswordanddisable
  • sp_setdefaultdatatypemapping
  • sp_setnetname
  • sp_setobdcertificate
  • sp_setoraclepackageversion
  • sp_setreplfailovermode
  • sp_setsubscriptionxactseqno
  • sp_settriggerorder
  • sp_setuserbylogin
  • sp_show_file_statistics
  • sp_showcolv
  • sp_showinitialmemo_xml
  • sp_showlineage
  • sp_showmemo_xml
  • sp_showpendingchanges
  • sp_showrowreplicainfo
  • sp_sm_detach
  • sp_spaceused%
  • sp_sparse_columns%
  • sp_special_columns%
  • sp_sproc_columns%
  • sp_sqlagent%
  • sp_sqlexec
  • sp_srvrolepermission
  • sp_ssis_%
  • sp_start%
  • sp_statistics%
  • sp_stop%
  • sp_stored_procedures
  • sp_subscribe
  • sp_subscription%
  • sp_syscollector_%
  • sp_sysdac_%
  • sp_sysmail_activate
  • sp_sysmanagement_%
  • sp_syspolicy%
  • sp_syspolicy_%
  • sp_sysutility_%
  • sp_table%
  • sp_target_server_summary
  • sp_testlinkedserver
  • sp_trace_%
  • sp_try_set_session_context
  • sp_unbindefault
  • sp_unbindrule
  • sp_uniquetaskname
  • sp_unprepare
  • sp_unregister%
  • sp_unsetapprole
  • sp_unsubscribe
  • sp_update_agent_profile
  • sp_update_alert
  • sp_update_category
  • sp_update_job
  • sp_update_jobschedule
  • sp_update_jobstep
  • sp_update_log_shipping_monitor_info
  • sp_update_notification
  • sp_update_operator
  • sp_update_proxy
  • sp_update_replication_job_parameter
  • sp_update_schedule
  • sp_update_targetservergroup
  • sp_update_user_instance
  • sp_updateextendedproperty
  • sp_updatestats
  • sp_upgrade_log_shipping
  • sp_user_counter%
  • sp_usertypes%
  • sp_validate%
  • sp_validate_user
  • sp_verify_alert
  • sp_verify_category
  • sp_verify_category_identifiers
  • sp_verify_credential_identifiers
  • sp_verify_job
  • sp_verify_job_date
  • sp_verify_job_identifiers
  • sp_verify_job_time
  • sp_verify_jobproc_caller
  • sp_verify_jobstep
  • sp_verify_login_identifiers
  • sp_verify_notification
  • sp_verify_operator
  • sp_verify_operator_identifiers
  • sp_verify_performance_condition
  • sp_verify_proxy
  • sp_verify_proxy_identifiers
  • sp_verify_proxy_permissions
  • sp_verify_schedule
  • sp_verify_schedule_identifiers
  • sp_verify_subsystem
  • sp_verify_subsystem_identifiers
  • sp_verify_subsystems
  • sp_verifypublisher
  • sp_views%
  • sp_vupgrade%
  • sp_who
  • sp_who2
  • sp_write_sysjobstep_log
  • sp_xa_%
  • sp_xml_preparedocument
  • sp_xml_removedocument
  • sp_xml_schema_rowset%
  • sp_xp_cmdshell_proxy_account
  • sp_xtp_%
  • sp_sqljdbc_%
  • xp_%

Babelfish for PostgreSQL Links