SQL Source Control wont stop reporting geometry objects changed.
It keeps saying these need to be 'commited', even though they are up to date.
ALTER TABLE [dbo].[Cities] ADD CONSTRAINT [enforcesridgeometryCity] CHECK (([STSrid]=(0)))
ALTER TABLE [dbo].[Cities] ADD CONSTRAINT [enforcesridgeometryCity] CHECK (([geom].[STSrid]=(0)))
Table recreation code.
CREATE TABLE [dbo].[Cities](
[CityID] [int] IDENTITY(1,1) NOT NULL,
[State] [char](2) NULL,
[StateID] [int] NULL,
[Name] [nvarchar](255) NULL,
[LSAD] [tinyint] NULL,
[LSADTRANS] [nvarchar](16) NULL,
[geom] [geometry] NULL,
CONSTRAINT [PKCityF2D21A9643D61337] PRIMARY KEY CLUSTERED
(
[CityID] ASC
)WITH (PADINDEX = OFF, STATISTICSNORECOMPUTE = OFF, IGNOREDUPKEY = OFF, ALLOWROWLOCKS = ON, ALLOWPAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Cities] WITH CHECK ADD CONSTRAINT [enforcesridgeometry_City] CHECK (([geom].[STSrid]=(0)))
GO
ALTER TABLE [dbo].[Cities] CHECK CONSTRAINT [enforcesridgeometry_City]
GO
![](https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
We think this has been fixed in v1.0. If you are still having a problem with this issue, then please contact support@red-gate.com.
-
David Atkinson commented
I'm trying to reproduce this.
ALTER TABLE [dbo].[Cities] ADD CONSTRAINT [enforce_srid_geometry_City] CHECK (([STSrid]=(0))) isn't valid for me. This complains that STSrid is an invalid column name.
What are the exact steps to reproduce this?