thanks jack! Yaah dats rite

sp_addrole worked!

hey Jack Thanks for reply

actually I had to drop a user but it was not allowing me to do that.

So i was tryng get around this problem by dropping ...