Ken,
>Both .NET Data Access and VFP use SP_ExecuteSQL to do their work with SQL Server. Check the profiler and you'll see this.<I don't think this is correct (at least for .NET ... don't know about VFP). If you're executing a Stored Proc from your .NET DataAccess, the Profiler shows that you just execute that Stored Proc ... there is no SP_ExecuteSQL being called.
~~Bonnie
>Thanks,
>
>>>The actual issue is with sp_executeSQL - has the same problem. The Dynamic SQL example just illustrated the problem.
>>
>>Ken,
>>
>>I'm still inclined to ask what it is exactly that you are trying to achieve? Procs like sp_executeSQL are more for internal usage by SQL Server and they are great for building schema tools and the like, but aren't really intended for end-user application usage.
>>
>>Besides, if you outline the scenario you are trying to accomplish, we may be able to give you a solution, solutions, or alternate ideas.
>>
>>Chad