Click here to Skip to main content
15,885,799 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi ,

I am in the middle of developing we application , but sometimes after registration is one from my aspx form , when come to check entry in my database tabele .

Identity column suddenly jumps to 1001 and continues with that . please suggest

VB
1
2
1001
1002
1003
1004
Posted
Updated 25-May-15 21:01pm
v2
Comments
Maciej Los 26-May-15 3:31am    
Have you made changes to the structure of table?
Torakami 26-May-15 3:46am    
No i havent made any changes
[no name] 26-May-15 5:45am    
could you please post script of the specific table
Torakami 26-May-15 6:05am    
USE [GroupSavings]
GO

/****** Object: Table [dbo].[tblUsers] Script Date: 26-05-2015 15:33:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tblUsers](
[UserId] [int] IDENTITY(1,1) NOT NULL,
[FirstName] [varchar](50) NOT NULL,
[LastName] [varchar](50) NOT NULL,
[EmailAddress] [nvarchar](100) NOT NULL,
[UserName] [nvarchar](20) NOT NULL,
[Password] [nvarchar](15) NOT NULL,
[Gender] [int] NULL,
[RoleId] [int] NOT NULL,
[MobileNumber] [varchar](15) NULL,
[Address1] [varchar](max) NULL,
[Address2] [varchar](max) NULL,
[Pincode] [varchar](15) NULL,
[CityName] [varchar](50) NULL,
[StateId] [int] NULL,
[CountryId] [int] NULL,
[ContributionStartDate] [datetime] NULL,
[TimeStamp] [datetime] NULL CONSTRAINT [DF__tblUsers__TimeSt__173876EA] DEFAULT (getdate()),
[DataForYear] [int] NULL CONSTRAINT [DF__tblUsers__DataFo__182C9B23] DEFAULT (datepart(year,getdate())),
[IsActive] [bit] NULL CONSTRAINT [DF__tblUsers__IsActi__1920BF5C] DEFAULT ((1)),
[IsDeleted] [bit] NULL CONSTRAINT [DF__tblUsers__IsDele__1A14E395] DEFAULT ((0)),
[Photo] [nvarchar](100) NULL,
[IsActiveForTrip] [bit] NULL,
[IsAdmin] [bit] NULL,
[TeamId] [int] NULL,
CONSTRAINT [pk_UserId] PRIMARY KEY CLUSTERED
(
[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [uk_Email] UNIQUE NONCLUSTERED
(
[EmailAddress] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [uk_UserName] UNIQUE NONCLUSTERED
(
[UserName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tblUsers] WITH CHECK ADD CONSTRAINT [fk_tblUserDetails_tblTeamDetails_TeamId] FOREIGN KEY([TeamId])
REFERENCES [dbo].[tblTeamDetails] ([TeamId])
GO

ALTER TABLE [dbo].[tblUsers] CHECK CONSTRAINT [fk_tblUserDetails_tblTeamDetails_TeamId]
GO

ALTER TABLE [dbo].[tblUsers] WITH CHECK ADD CONSTRAINT [fk_tblUsers_tblCountries_CountryId] FOREIGN KEY([CountryId])
REFERENCES [dbo].[tblCountries] ([CountryId])
GO

ALTER TABLE [dbo].[tblUsers] CHECK CONSTRAINT [fk_tblUsers_tblCountries_CountryId]
GO

ALTER TABLE [dbo].[tblUsers] WITH CHECK ADD CONSTRAINT [fk_tblUsers_tblStates_StateId] FOREIGN KEY([StateId])
REFERENCES [dbo].[tblStates] ([StateId])
GO

ALTER TABLE [dbo].[tblUsers] CHECK CONSTRAINT [fk_tblUsers_tblStates_StateId]
GO


1 solution

Please, refer this: Azure Database Identity Field Jump[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900