Have a website that will insert data via a stored procedure. The stored procedure connects with the db, inserts the data, disconnects. Periodically, will get an error message that the identity_insert is off. Yet, when execute again.. everything is fine.
Would like to know how to prevent this error. Should the stored procedure set Identity_Insert to on just before the insert or is there another reason for this message?