Functions and stored procedures for Amazon RDS for Microsoft SQL Server

Following, you can find a list of the Amazon RDS functions and stored procedures that help automate SQL Server tasks.

Task type	Procedure or function	Where it's used
Administrative tasks	`rds_drop_database`	Dropping a Amazon RDS for Microsoft SQL Server database
	`rds_failover_time`	Determining the last failover time for Amazon RDS for SQL Server
	`rds_manage_view_db_permission`	Deny or allow viewing database names for Amazon RDS for SQL Server
	`rds_modify_db_name`	Renaming a Amazon RDS for Microsoft SQL Server database in a Multi-AZ deployment
	`rds_read_error_log`	Viewing error and agent logs
	`rds_set_configuration`	This operation is used to set various DB instance configurations: Change data capture for Multi-AZ instances Setting the retention period for trace and dump files Compressing backup files
	`rds_set_database_online`	Transitioning a Amazon RDS for SQL Server database from OFFLINE to ONLINE
	`rds_set_system_database_sync_objects` `rds_fn_get_system_database_sync_objects` `rds_fn_server_object_last_sync_time`	Turning on SQL Server Agent job replication
	`rds_show_configuration`	To see the values that are set using `rds_set_configuration`, see these topics: Change data capture for Multi-AZ instances Setting the retention period for trace and dump files
	`rds_shrink_tempdbfile`	Shrinking the tempdb database
Change data capture (CDC)	`rds_cdc_disable_db`	Disabling CDC
Change data capture (CDC)	`rds_cdc_enable_db`	Enabling CDC
Database Mail	`rds_fn_sysmail_allitems`	Viewing messages, logs, and attachments
	`rds_fn_sysmail_event_log`	Viewing messages, logs, and attachments
	`rds_fn_sysmail_mailattachments`	Viewing messages, logs, and attachments
	`rds_sysmail_control`	This operation is used in starting and stopping the mail queue: Starting the mail queue Stopping the mail queue
	`rds_sysmail_delete_mailitems_sp`	Deleting messages
Native backup and restore	`rds_backup_database`	Backing up a database
	`rds_cancel_task`	Canceling a task
	`rds_finish_restore`	Finishing a database restore
	`rds_restore_database`	Restoring a database
	`rds_restore_log`	Restoring a log
Amazon S3 file transfer	`rds_delete_from_filesystem`	Deleting files on the RDS DB instance
	`rds_download_from_s3`	Downloading files from an Amazon S3 bucket to a SQL Server DB instance
	`rds_gather_file_details`	Listing files on the RDS DB instance
	`rds_upload_to_s3`	Uploading files from a SQL Server DB instance to an Amazon S3 bucket
Microsoft Distributed Transaction Coordinator (MSDTC)	`rds_msdtc_transaction_tracing`	Using transaction tracing
SQL Server Audit	`rds_fn_get_audit_file`	Viewing audit logs
Transparent Data Encryption	`rds_backup_tde_certificate` `rds_drop_tde_certificate` `rds_restore_tde_certificate` `rds_fn_list_user_tde_certificates`	Support for Transparent Data Encryption in SQL Server
Microsoft Business Intelligence (MSBI)	`rds_msbi_task`	This operation is used with SQL Server Analysis Services (SSAS): Deploying SSAS projects on Amazon RDS Adding a domain user as a database administrator Backing up an SSAS database Restoring an SSAS database This operation is also used with SQL Server Integration Services (SSIS): Administrative permissions on SSISDB Deploying an SSIS project This operation is also used with SQL Server Reporting Services (SSRS): Granting access to domain users Revoking system-level permissions
Microsoft Business Intelligence (MSBI)	`rds_fn_task_status`	This operation shows the status of MSBI tasks: SSAS: Monitoring the status of a deployment task SSIS: Monitoring the status of a deployment task SSRS: Monitoring the status of a task
SSIS	`rds_drop_ssis_database`	Dropping the SSISDB database
SSIS	`rds_sqlagent_proxy`	Creating an SSIS proxy
SSRS	`rds_drop_ssrs_databases`	Deleting the SSRS databases

Warning Javascript is disabled or is unavailable in your browser.

To use the Amazon Web Services Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.

Document Conventions

Unsupported and limited feature support

Local time zone