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_columnssp_sproc_columns_100sp_helprolesp_helprolemember
The following System-provided Stored Procedures are supported for versions 1.2.0 and higher:
sp_table_privilegessp_column_privilegessp_special_columnssp_fkeyssp_stored_proceduresxp_qvsp_describe_undeclared_parameterssp_helpuser
The following System-provided Stored Procedures are supported for versions 1.1.0 and higher:
sp_statisticssp_statistics_100sp_updatestatssp_pkeyssp_databasessp_cursorsp_cursoropensp_cursorpreparesp_cursorexecutesp_cursorprepexecsp_cursorunpreparesp_cursorfetchsp_cursoroptionsp_cursorclose
The following System-provided Stored Procedures are supported for versions 1.0.0 and higher:
sp_helpdbsp_getapplocksp_releaseapplocksp_columnssp_columns_100sp_columns_managedsp_cursor_listsp_datatype_infosp_datatype_info_100sp_describe_CURSORsp_DESCRIBE_FIRST_RESULT_SETsp_DESCRIBE_UNDECLARED_PARAMETERSsp_executesqlsp_oledb_ro_usrnamesp_preparesp_tablecollations_100sp_tablessp_unpreparesp_statisticssp_statistics_100sp_updatestatssp_databasessp_cursorsp_cursoropensp_cursorpreparesp_cursorexecutesp_cursorprepexecsp_cursorunpreparesp_cursorfetchsp_cursoroptionsp_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_adjustpublisheridentityrangesp_agent_%sp_alter_nt_job_mem_configssp_altermessagesp_apply_job_to_targetssp_approlepasswordsp_article%sp_assembl%sp_attach%sp_audit_writesp_autoadmin_%sp_autoindex%sp_autostatssp_availability_group_command_internalsp_backup_%sp_bcp_dbcmptlevelsp_begin_parallel_nested_transp_bindefaultsp_bindrulesp_bindsessionsp_browsemergesnapshotfoldersp_browsereplcmdssp_browsesnapshotfoldersp_build_histogramsp_can_tlog_be_appliedsp_catalogs%sp_cdc_%sp_certify_removablesp_change%sp_check%sp_clean%sp_clear_dbmaintplan_by_dbsp_cloud_update_blob_tiersp_column%sp_commit_parallel_nested_transp_configure%sp_constr_col%sp_control_dbmasterkey_passwordsp_control_plan_guidesp_convert_jobid_to_charsp_copymergesnapshotsp_copysnapshotsp_copysubscriptionsp_create_file_statisticssp_create_jobsp_create_log_shipping_monitor_accountsp_create_plan_guide%sp_create_removablesp_createmergepalrolesp_createorphansp_createstatssp_createtranpalrolesp_cursor%sp_cycle_agent_errorlogsp_cycle_errorlogsp_databasessp_datatype_info%sp_db_ebcdic277_2sp_db_increased_partitionssp_db_selective_xml_indexsp_db_vardecimal_storage_formatsp_dbcmptlevelsp_dbfixedrolepermissionsp_dbmmonitor%sp_dbremovesp_ddopensp_defaultdbsp_defaultlanguagesp_delete%sp_denyloginsp_dependssp_describe_%sp_detach_dbsp_detach_schedulesp_diagnostic_showplan_log_dbidsp_disableagentoffloadsp_distcounterssp_do_backupsp_downloaded_row_limitersp_drop%sp_dsninfosp_enable_heterogeneous_subscriptionsp_enable_sql_debugsp_enableagentoffloadsp_enclave_send_keyssp_enlist_tsxsp_enum%sp_enum_login_for_proxysp_enum_proxy_for_subsystemsp_enum_sqlagent_subsystemssp_enum_sqlagent_subsystems_internalsp_estimate_data_compression_savingssp_estimated_rowsize_reduction_for_vardecimalsp_executesp_execute_external_scriptsp_execute_remotesp_expired_subscription_cleanupsp_externalmailqueuelistenersp_fido_%sp_filestream%sp_firstonly_bitmapsp_fkeyssp_flush%sp_force_slog_truncationsp_foreign%sp_fulltext_%sp_generate_agent_parametersp_generate_server_descriptionsp_generate_target_server_job_assignment_sqlsp_generatefilterssp_get_backup_diagnosticssp_get_chunked_jobstep_paramssp_get_composite_job_infosp_get_database_scoped_credentialsp_get_distributorsp_get_encryption_optionsp_get_file_statistics_hashsp_get_job_alertssp_get_job_status_mergesubscription_agentsp_get_jobstep_db_usernamesp_get_log_shipping_monitor_infosp_get_mergepublishedarticlepropertiessp_get_message_descriptionsp_get_oracle_publisher_metadatasp_get_proxy_propertiessp_get_query_templatesp_get_redirected_publishersp_get_schedule_descriptionsp_get_sqlagent_propertiessp_get_striping_optionsp_get_traceflag_status_internalsp_getagentparameterlistsp_getapplocksp_getattachmentdatasp_getbindtokensp_getdefaultdatatypemappingsp_getmergedeletetypesp_getprocessorusagesp_getpublisherlinksp_getqueuedarticlesynctraninfosp_getqueuedrowssp_getschemalocksp_getsqlqueueversionsp_getsubscription_status_hsnapshotsp_getsubscriptiondtspackagenamesp_gettopologyinfosp_getvolumefreespacesp_grant_login_to_proxysp_grant_proxy_to_subsystemsp_grant_publication_accesssp_grantdbaccesssp_grantloginsp_help%sp_http_%sp_identitycolumnforreplicationsp_ih%sp_index%sp_internal_alter_nt_job_limitssp_invalidate_textptrsp_is_makegeneration_neededsp_is_sqlagent_startingsp_isprohibitedsp_ivindexhasnullcolssp_jobhistory_row_limitersp_kill_filestream_non_transacted_handlessp_kill_oldest_transaction_on_secondarysp_lightweightmergemetadataretentioncleanupsp_link_publicationsp_linkedservers%sp_locksp_log_shipping_%sp_logshippinginstallmetadatasp_lookupcustomresolversp_mailitemresultsetssp_maintplan_%sp_manage_jobs_by_loginsp_mapdown_bitmapsp_markpendingschemachangesp_marksubscriptionvalidationsp_memory_optimized_cs_migrationsp_merge%sp_migrate_user_to_containedsp_monitorsp_ms%sp_multi_server_job_summarysp_new_parallel_nested_tran_idsp_notify_operatorsp_oa%sp_objectfilegroupsp_oledb%sp_orbitmapsp_passwordsp_peerconflictdetection_tableaugsp_polybase_%sp_post_msx_operationsp_postagentinfosp_posttracertokensp_preparesp_prepexecsp_prepexecrpcsp_primary%sp_procedure%sp_process_DialogTimersp_processlogshipping%sp_processresponsesp_procoptionsp_prop_oledb_providersp_provider_types%sp_publication%sp_publish%sp_purge_jobhistorysp_query_store_%sp_rbpex_exec_cmdsp_rda_%sp_read_settingssp_readerrorlogsp_readrequestsp_reassign_proxysp_recompilesp_redirect_publishersp_refresh%sp_register%sp_reinit%sp_releaseapplocksp_releaseschemalocksp_remote_data_archive_eventsp_remoteoptionsp_remove%sp_renamesp_renamedbsp_repl%sp_requestpeer%sp_reserve_http_namespacesp_reset_connectionsp_reset_session_contextsp_resetsnapshotdeliveryprogresssp_resetstatussp_resign_databasesp_resolve_loginssp_restoredbreplicationsp_restoremergeidentityrangesp_resync%sp_revoke%sp_rollback_parallel_nested_transp_runmailquerysp_schemafiltersp_schemata_rowsetsp_script%sp_sem_add_messagesp_sem_drop_messagesp_send_dbmailsp_sendmailmessagesp_sendmailqueuessp_sequence_get_rangesp_server_diagnosticssp_server_infosp_serveroptionsp_set_db_backupsp_set_distributed_query_contextsp_set_instance_backupsp_set_local_timesp_set_parametersp_set_session_contextsp_set_session_resource_groupsp_set_sqlagent_propertiessp_setapprolesp_setautosapasswordanddisablesp_setdefaultdatatypemappingsp_setnetnamesp_setobdcertificatesp_setoraclepackageversionsp_setreplfailovermodesp_setsubscriptionxactseqnosp_settriggerordersp_setuserbyloginsp_show_file_statisticssp_showcolvsp_showinitialmemo_xmlsp_showlineagesp_showmemo_xmlsp_showpendingchangessp_showrowreplicainfosp_sm_detachsp_spaceused%sp_sparse_columns%sp_special_columns%sp_sproc_columns%sp_sqlagent%sp_sqlexecsp_srvrolepermissionsp_ssis_%sp_start%sp_statistics%sp_stop%sp_stored_proceduressp_subscribesp_subscription%sp_syscollector_%sp_sysdac_%sp_sysmail_activatesp_sysmanagement_%sp_syspolicy%sp_syspolicy_%sp_sysutility_%sp_table%sp_target_server_summarysp_testlinkedserversp_trace_%sp_try_set_session_contextsp_unbindefaultsp_unbindrulesp_uniquetasknamesp_unpreparesp_unregister%sp_unsetapprolesp_unsubscribesp_update_agent_profilesp_update_alertsp_update_categorysp_update_jobsp_update_jobschedulesp_update_jobstepsp_update_log_shipping_monitor_infosp_update_notificationsp_update_operatorsp_update_proxysp_update_replication_job_parametersp_update_schedulesp_update_targetservergroupsp_update_user_instancesp_updateextendedpropertysp_updatestatssp_upgrade_log_shippingsp_user_counter%sp_usertypes%sp_validate%sp_validate_usersp_verify_alertsp_verify_categorysp_verify_category_identifierssp_verify_credential_identifierssp_verify_jobsp_verify_job_datesp_verify_job_identifierssp_verify_job_timesp_verify_jobproc_callersp_verify_jobstepsp_verify_login_identifierssp_verify_notificationsp_verify_operatorsp_verify_operator_identifierssp_verify_performance_conditionsp_verify_proxysp_verify_proxy_identifierssp_verify_proxy_permissionssp_verify_schedulesp_verify_schedule_identifierssp_verify_subsystemsp_verify_subsystem_identifierssp_verify_subsystemssp_verifypublishersp_views%sp_vupgrade%sp_whosp_who2sp_write_sysjobstep_logsp_xa_%sp_xml_preparedocumentsp_xml_removedocumentsp_xml_schema_rowset%sp_xp_cmdshell_proxy_accountsp_xtp_%sp_sqljdbc_%xp_%