I have set the EMP_ID column in my database as the Primary Key. I mean it has primary key on this 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.
Comments
[link=http://www.programmersheaven.com/mb/database/Board.aspx]Database & SQL forums[/link]