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