>Hello Nadya, thanks for the concern.
>
>Im using the native REPLACE command to update the sql table via VIEW.
>
>For your info my IDENTITY field is not updatable bec it is already auto-increment datatype on the sql server, so when I execute my REPLACE command im actually not touching the value of that IDENTITY field.
>
>Is there a way that this IDENTITY_INSERT can be turned ON? if yes is that the solution to this problem.
>
>So im still confused as of now why i am arriving at this err msg.
>
>I hope you can help me on this one.
>
>Thank you very much. Godspeed :)
See
http://msdn.microsoft.com/library/en-us/tsqlref/ts_set-set_7zas.asp
If it's not broken, fix it until it is.
My Blog