I have created a stored procedure in SQL Server. I can execute this SP from Sql Server Management Studio fine. But when I try to execute this SP from VFP, I get the following error:

***********
"Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'mytest', database 'MyDatabase', owner 'dbo'."
***********

I can query any table in SQL Server with SQL Pass Through. And I can call the System Stored Procedures but I can't call a Stored Procedure that I created.

What do I have to do to call a SP that I created from VFP?

Thanks,

Jerry