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