Can not insert into table with Identity insert .
Posted on 2006-06-29
Hi, I have a code to insert and some how I could not insert properly. I found out that the table I use has a column that is defined as Identity increament. Currently my table has only 3 roles so the column with identity has entry 1, 2, 3.
So to test this I went to the query analyzer and type the following SQL statement:
SET IDENTITY_INSERT fintracreport OFF
insert into fintracreport values(5,'1',1,'1',1)
Yet I still get the following error:
Server: Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'fintracreport' can only be specified when a column list is used and IDENTITY_INSERT is ON.
Any ideas about this? any helps are appriciated.