To accomplish this action, set property PartitionScheme

SSMS 18.X error when creating NonClustered index

This seems to be a bug in SSMS as the index can be created using TSQL just fine here is the full error message.

TITLE: Microsoft SQL Server Management Studio

——————————

 

Exception has been thrown by the target of an invocation. (mscorlib)

 

——————————

ADDITIONAL INFORMATION:

 

To accomplish this action, set property PartitionScheme. (Microsoft.SqlServer.Smo)

 

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=15.0.18040.0+((SSMS_Rel).180920-2155)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyNotSetExceptionText&LinkId=20476

 

——————————

BUTTONS:

 

OK

——————————