hello
I want a problem about using application role. 
When i connect to sql server from vb application through application role  
and i want to open a recordset on a table(a stored procedure) and i have 
another open recordset on the same table, although i grant execting 
permission on the stored procedures to application  role , i recieve an 
error that tell me "executing permission denied on 'sp name'".
if you can help me, please send me answer.
with thanks