I'm building an intranet (non-public) site with Windows 2000 Server, IIS

5.0, ASP, and a SQL 7.0 database.  The database and webserver are on the

same computer.



I'd like to only use Windows Integrated Authentication on IIS and

application roles on my SQL database.



Using application roles in my SQL DB, every time I want to execute a SQL

string, I need to:



1)      Create my ADO objects. 

2)      Log in to the database with a connection string 

3)      Execute the sp_setapprole stored procedure passing in the

Application role user id and password.

4)      Execute the SQL statement 

5)      Destroy my ADO objects. 



Is there a better, faster way to do this?  



Thanks