id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,external_id 852,Cannot insert features into SQL Server,jng,RomicaDascalescu,"There is a showstopping defect in the SQL Server provider that makes it impossible to insert features into a SQL Server Feature Source in MapGuide in both transactional and non-transactional modes. Attached is a simple .net program demonstrating the problem The `MapGuideTest` data store is a foreign schema with a table `GeomTest`, created with the following DDL: {{{ CREATE TABLE [dbo].[GeomTest]( [ID] [int] IDENTITY(1,1) NOT NULL, [Geom] [geometry] NULL, CONSTRAINT [PK_GeomTest] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE SPATIAL INDEX [SPATIAL_GeomTest] ON [dbo].[GeomTest] ( [Geom] )USING GEOMETRY_GRID WITH ( BOUNDING_BOX =(3462000, 5542000, 3486000, 5566000), GRIDS =(LEVEL_1 = MEDIUM,LEVEL_2 = MEDIUM,LEVEL_3 = MEDIUM,LEVEL_4 = MEDIUM), CELLS_PER_OBJECT = 16, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] }}}",defect,closed,blocker,3.7.0,SQLServer Spatial,3.7.0,1,fixed,,gBecker,