Forums

This topic is locked

IDENTITY_INSERT problem

Posted 04 Oct 2001 17:03:07
1
has voted
04 Oct 2001 17:03:07 Kevin Lynn posted:
I'm trying to do a simple record insert into SQLServer7 using the standard UD4 insert behavior (jsp). This seems to work fine for records there the key is "autonumber", but I get the following error in cases where the key is not autonumber:
Cannot insert explicit value for identity column in table 'MMM_SITE_CONFIGURATION' when IDENTITY_INSERT is set to OFF.
Any help appreciated!

Reply to this topic