I'm making asp 2 app to connect to sql server 7 db. I'm thinking of trying to implement security thro sql server application roles. However, i'm having difficulty finding any examples of how to do this and am wondering if i am attempting the impossible. I've been trying to run sp_setapprole through my asp/ado code without any success. Would be grateful for any help anyone could give.