Problem inserting values.

[Omar Akhtar Sheikh]

I have set the EMP_ID column in my database as the Primary Key. I mean this is the primary key column. And when I try to insert values in my database table from the form in then it gives me an error as:          "Cannot insert explicit value for identity column in table 'Employees' when IDENTITY_INSERT is set to OFF." So, how is the IDENTITY_INSERT set to on. Where it is actually located so that I can modify it and start to insert values into my table. Moreover, when I remove the primary key from this column(EMP_ID) and uncheck the Allow Nulls checkbox then also my same problem persists. Kindly help me out. I am currently using SQL Server 2005.

[Ebube]

it depends on what you want to do. if you want to enable insertion on identity column SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON | OFF } otherwise remove identity from the emp_id column and insert the value from field

[Ebube]

sorry typo error i mean form not field

[okdeshpande]

I think you are trying to insert a value into a identity column. If you are inserting the value into intentionally then you have to set Identity_insert tablename on/off. else ignore this column while inserting, sql server automatically inserts records into this field.

[Robin_Roy]

If you have access to the Management Studio of SQL Server, try and check the property for the column of your table in design mode, check the Identity Specification property...