Voltar
-
Título
ALTER TABLESPACE from SMS storage to AUTOMATIC storage results in a DROP with no CREATE of dep -
Descrição
Changing the tablespace from SMS storage to Automatic results in a script that DROPs the tablespace and then CREATEs the tablespace but does not include any definitions for dependent objects.
Steps to Reproduce:
1. Open Object Explorer2. In the Tablespaces tab, right-click a SMS tablespace3. Click 'Alter Tablespace'
4. Select the General Tab. Change "Managed by" from "System" to "Automatic Storage"
5. Select the SQL Script tab.
Expected results:
Script is generated to drop and create tablespace and any dependent tables.
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.