| title | sp_pdw_database_encryption_regenerate_system_keys (SQL Data Warehouse) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/03/2017 | |
| ms.prod | sql | |
| ms.technology | system-objects | |
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | bb13e323-a984-4462-8b6d-6019c38ddd9d | |
| author | ronortloff | |
| ms.author | rortloff | |
| ms.reviewer | ||
| monikerRange | >= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allversions |
[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-pdw-md]
Use sp_pdw_database_encryption_regenerate_system_keys to rotate the certificate and database encryption key for internal databases that are encrypted when TDE is enabled on the appliance. This includes tempdb. This will succeed only if TDE is enabled.
-- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse
sp_pdw_database_encryption_regenerate_system_keys ; 0 (success) or 1 (failure)
The procedure has no parameters.
This procedure should be used when the traffic in the appliance is low.
Requires membership in the sysadmin fixed database role, or CONTROL SERVER permission.
The following example regenerates the database encryption keys.
EXEC sys.sp_pdw_database_encryption_regenerate_system_keys; sp_pdw_database_encryption (SQL Data Warehouse)
sp_pdw_log_user_data_masking (SQL Data Warehouse)