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
——————————
Please Consider Subscribing
