Hi BTerraberry,

Thank you for your time, that really worked. Thanks again.

Hello jvanderberg,

Thank you very much. That worked. Thanks for your time.

Thanks Lowell, that worked.

Lowel,

You are showing SQL Express and I am using 2005. I am not seeing a "Report" menu when i right-click on a database. Thanks for your...

This post was created in March of 2009 and now all of a sudden i am seeing responses. I could not follow ckuroda's instruction on how to see the dates...

I create this table thru an application that is using this script. After that within the same application, i add records to the tables. So i do not want to...

I Apologize. The reason why i started this thread is because the previous thread is under Administration. I have not received any solution from there so i thought a T-SQL...

There are no triggers on the table

the following is having the same issue:

http://www.generation-nt.com/us/instead-insert-inserted-identity-column-0-help-116980361.html

Just 1 record with zero. If i insert data manully using query analyzer, then the second record is inserted with the identity of 2.

Here is another user who is complaining...

This stored procedure and the table definition has been working since the past 2 years. I just scripted the table definition from another database and then created the table on...

Thanks for your time

Table Definition

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[customers](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Description] [nvarchar](300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[ContactPhone] [nvarchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Email]...

I misread your earlier post. IsIdentity is on. But i don't know if Identity insert is on. How can i tell?

Thanks.

Yes, Identity insert is ON. I just created the table. It has not been truncated or reseeded.

Thanks.

Thanks Paul and Gail for taking time. In this case what I will have to do is to insert the records into a temp table and thru a cursor check...

Gail,

Here is my data:

TestRoomtest session 22009-11-15 08:00:00.000AhmadAwada

TestRoomtest session 22009-11-15 08:00:00.000AhmadAwada

TestRoomtest session 22009-11-15 08:00:00.000AlastairKyle

TestRoomtest session 22009-11-15 08:00:00.000AlastairKyle

Veteran-s Educational 2009-11-15 13:30:00.000DavidRimm

Veteran-s Educational 2009-11-15 13:30:00.000Frédérique Penault-Llorca

Veteran-s Educational 2009-11-15 13:30:00.000GiuseppeViale

I need...