I need execute a "SQL Server store procedure" assigned to Id handler used by "VFP DBC connection". It doesn't work, or rather, it doesn't returns any error, but neither apply the "store procedure".

The "store procedure" is "SQL Server application role" it grants privileges to session ID on all tables of a database.

The code:

OPEN DATABASE myVFPdatabase
USE rvUsers  && remote view to SQL Server 'users' table with all grants
myHandler = CURSORGETPROP("ConnectHandle","rvUsers")
SQLEXEC(myHandler, "exec sp_setapprole 'userPower', 'myStrongPwd'")
USE rvSales  && remote view to SQL Server 'users' table now with grants applied by sp_setapprole
*-- Error here, no grants to use 'sales'table (select, etc.)

It works using SQL pass through:

myHandler = SQLCONNECT("myConn","myUser","myPwd")
SQLEXEC(myHandler,"select * from sales")
*-- Errorhere, no grants on 'sales'
SQLEXEC(myHandler, "exec sp_setapprole 'userPower', 'myStrongPwd'")
SQLEXEC(myHandler,"select *from sales")
*-- Ok, works fine!

Any idea ?
Thanks in advance

I'm using VFP 8 SP1, but using VFP9 ASQLHANDLES() neither works.