FIX: Error when SQL Server replication article contains either GEOGRAPHY_AUTO_GRID or GEOMETRY_AUTO_GRID

Applies to: Microsoft SQL Server 2016 Service Pack 1SQL Server 2016 EnterpriseSQL Server 2016 Developer

Symptoms


Assume that you publish a database that contains a spatial index that uses either GEOGRAPHY_AUTO_GRID or GEOMETRY_AUTO_GRID in Microsoft SQL Server 2016 or 2017. When you try to generate a snapshot for your publications, you receive an error message that resembles the following:

Incorrect syntax near the keyword 'WITH'. (Source: MSSQLServer, Error number: 156)

Resolution


This problem is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 4 for SQL Server 2017

       Cumulative Update 7 for SQL Server 2016 SP1

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.