Return
-
Title
ALTER TABLESPACE from SMS storage to AUTOMATIC storage results in a DROP with no CREATE of dep -
Description
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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.