October 26, 2001 at 1:46 pm
Could you please help me figure out my problem.
When I login as a sa and set IDENITITY column ON for a table. Insert works with no problem.
When a want to do insert into the same table using Stor proc with the IDENTITY SET still ON I am getting error message:
Cannot insert explicit value for identity column in table 'tblTag' when IDENTITY_INSERT is set to OFF.
Does it meant that it works only for one specific connection?
Thank you.
October 26, 2001 at 3:14 pm
quote:
Could you please help me figure out my problem.When I login as a sa and set IDENITITY column ON for a table. Insert works with no problem.
When a want to do insert into the same table using Stor proc with the IDENTITY SET still ON I am getting error message:
Cannot insert explicit value for identity column in table 'tblTag' when IDENTITY_INSERT is set to OFF.
Does it meant that it works only for one specific connection?
Thank you.
I guess it works only within one connection even if you are an sa, and you can do it only for one table within this connection
Edited by - liyaka on 10/26/2001 3:14:44 PM
October 26, 2001 at 3:17 pm
Yes, its a connection specific setting.
Andy
October 26, 2001 at 4:14 pm
It's also table specific. Only one table at a time, so be sure to turn it off when you are done.
Steve Jones
October 29, 2001 at 2:31 pm
Thank you.
October 29, 2001 at 2:35 pm
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply