Primary key column number bounced in sql

Kalyani Shevale

7y1.1k

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.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sonu Gupta7y ago
Its possible that transactions are performing an insert and then rolling it back. Or data is being deleted after insertion.
0
Kalyani Shevale7y ago
@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
0
Sonu Gupta7y ago
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
+1
Kalyani Shevale7y ago
@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
0
Nirav Gandhi7y ago
Please share a table design.
+1
Kalyani Shevale7y ago
how to set in godadday server plesk panel on this issue??
0
Vishal Patel7y ago
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
+2