JamesLast99
Registered User.
- Local time
- Yesterday, 18:32
- Joined
- Apr 9, 2009
- Messages
- 128
I have a trigger which EXECs a proc. the proc set indentity insert so I can exolicitly post the IDs to a Key, identity field.I get an error cos the user who fired the triiger hasn't got permissions to use SET to change identity insert.How can I run the proc, via the triiger as someone with the correct permissions.Ta!