SAP ABAP Message Class SMMSS_DDIC Message Number 010 (FILEGROUP is not set for the table)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ SMSS_DDIC (Package) Data Dictionary Porting for Microsoft SQL Server

Attribute

Message class	SMMSS_DDIC
Short Description	DDIC Messages for Microsoft SQL Server
Message Number	010
Documentation status		Space: object requires documentation
Authorization check Error Message	☐
Changed On	20130531

Message Text

FILEGROUP is not set for the table

Help Document

Diagnosis

You have not set FILEGROUP for the table; however, the table has a clustered index for which you specified a different filegroup than this filegroup. During conversion, the table would first be created in its current filegroup and then in the filegroup selected for the clustered index. Depending on the size of the table, this could be very expensive.

System Response

Procedure

If you do not want to convert the table, but rather move it into the filegroup you selected for the index by creating a new clustered index (activate and adjust database), you do not have to do anything. However, if you want to convert the table, you should select the same filegroup as for the clustered index.

Procedure for System Administration

History

Last changed on/by	20130531	SAP
SAP Release Created in