I was talking with a friend that works with SQL Server 2K.
I told him that I was using VFP as frontend and using SPT to call Stored Procedures(SP)
passing the necessary parameters to the SP in SQL Server.
My intention was to increase speed in SQL Server, than I understand that
if call more than one time the same SP in SQL Server, it would take advantage
that it will keep in memory the execution plan, saving the overhead of
recompiling the statement.

He told me that the way VFP passes the statement using SQLEXEC( ),
in SQL Server it works like this:

Execute sp_ExecuteSql ‘SELECT au_Name FROM Authors’.
He mentioned that the Execution Plan is the sp_ExecuteSql and not the SELECT,
so if I have a same/silimar SELECT statement I WONT get the benefit of the execution plan
in SQL Server memory.

If I call a SP in SQL Server passing the necessary parameters using SPT, will I get
the advantage of the execution plan when I call the same SP ?
And if I call a very similar SP in SQL Server also ?

If using VFP and I can take the advantage of the execution plan, how can I show it using
SQL Profiler. What I should look in Profiler, and if necessary configure to get it.

Thanks in Advance.

Peter