I need to insert values into an identity field, but I don't know what the normal status of IDENTITY_INSERT is for this database. Is there any way to determine the status of IDENTITY_INSERT prior to running the INSERT statement?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.