I need to write my data into an MSSpatial database with a spatial index. However, when setting the SQLSERVER writer to the following then I do not get any spatial index generated.

When I now go into SSMS to ‘clean up’ after FME Form then I face the issue that I have a column id of type identity, but it isn’t a PrimaryKey. Looking into the possibilities to set an index in the attribute definitions I can see that I set the index to ClusteredNotNull. I can also see there is no possibility to generate a ClusteredPrimaryKey, as it is necessary to create the spatial index.

I assume I am going somewhere wrong here and would like to hear how I get my spatial index generated and applied when I am writing the data, instead of following up in SQL.