Hi Guys,

I got the problem.

Issue: DBCC CHECKIDENT ( 'dbo.PVAPeriodIDLog')

Checking identity information: current identity value '29141918', current column value '29142774'.

DBCC execution completed. If DBCC printed error messages,...

Hi,

No its not trying to insert into identity column.

below is the Table structure.

CREATE TABLE PeriodLog

(

ID INT PRIMARY KEY IDENTITY(1,1),

Message VARCHAR(10),

Operation CHAR (1)

)

GO

CREATE TRIGGER [dbo].[TR_PeriodID_IUD] ON [dbo].[Period]

FOR INSERT, UPDATE, DELETE...