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?