Devart Forums

Posted: **Sun 11 Aug 2013 13:18**

Works fine in SSMS, but this column will not increment in Studio for SS. The number of QuoteQtyPK is set to 2 no matter how many records are in the table, and never increments, therefore the insert of course fails. Actually I think it should increment as soon as the insert is started, even before any data is entered, but doesn't. It's always 2. This is not a situation of the insert failing due to bad data.

Code: Select all

CREATE TABLE [QuoteTool1.1].dbo.tblQuoteQty(
  QuoteQtyPK INT IDENTITY,
  QuotePK INT NOT NULL,
  Qty SMALLINT NOT NULL DEFAULT (0),
  Kind TINYINT NOT NULL DEFAULT (0),
  Split TINYINT NOT NULL DEFAULT (0),
  CONSTRAINT PK_tblQuoteQty2 PRIMARY KEY (QuoteQtyPK)
) ON [PRIMARY]
GO

Thanks.

Posted: **Mon 12 Aug 2013 10:39**

We are aware of this issue and will fix it in one of the next builds of dbForge Studio for SQL Server. We will notify you once it's available for downloading.

Devart Forums

Identity column won't increment

Identity column won't increment

Re: Identity column won't increment