I tried to create or assign a user defined role within a Trigger it gave me
an error "sp_role can't execute within a transaction" ?

althoug I used sp_addlogin within a the same trigger and it was successfuly
executed


Hamed,
hahamed@hotmail.com