Primary key column number bounced in sql

Question

I have one table this table 'Id' filed this primary key assigned and identity properties id true but some time automatically id is bounced and go to next 100 ro 10000 number how to overcome in sql please help me.

Vishal Patel · Answer

Hello Kalyani Please follow below process to overcome this problem : 1) Go to the SQL Server Configuration Manager. Next, right-click on the Instance Name, and select the properties from the context menu. 2) Selecting the properties window will open the following window 3) Go to the Startup Parameters Tab and add -T272 4) Click Apply 5) Click OK and restart the SQL Server instance Thanks

Sonu Gupta · Answer

Hi, Go to below link...Its explain step by step - https://www.codeproject.com/Tips/668042/SQL-Server-2012-Auto-Identity-Column-Value-Jump-Is

Kalyani Shevale · Answer

@Nirav please check table design USE [pps_chand_updated] GO /****** Object: Table [dbo].[tbl_admission_form_transaction_detail] Script Date : 26/08/2019 10:48:03 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tbl_admission_form_transaction_detail]( [Id] [ int ] IDENTITY(1,1) NOT NULL , [transaction_id] [ int ] NOT NULL , [form_id] [ int ] NULL , [ceated_date] [datetime] NULL , CONSTRAINT [PK_tbl_admission_form_transaction_detail_1] 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

Nirav Gandhi · Answer

Please share a table design.

Kalyani Shevale · Answer

how to set in godadday server plesk panel on this issue??

Sonu Gupta · Answer

Its possible that transactions are performing an insert and then rolling it back. Or data is being deleted after insertion.

Kalyani Shevale · Answer

@sonu gupta my bouncing number is bouncing ant time not range form 1000 to...10000 my bouncing is 1 to 5..or 7....any time

Primary key column number bounced in sql

Answers (7)