identity insert

[shubhangi]

Hi,

I have created a update trigger on a table which has auto incremental field.
trigger contains "set identity_insert on" statement.
I am facing problem that

only logins who have db_owner rights can update but others can't

why other logins having db read & write rights are unable to fire update statements through query analyser.

reply ASAP

Thanks
Shubhangi