Thanks phil for the last answer.

What I need is to retain the identity field as this number needs to autogenerated as to change the code would be too much work in a complex system.

So I am still back to the need to turn on the identity insert option globally so that any user other than a dbo can do insert a value.

Karyn