Thanks, Sergey. Exactly what I was looking for after finding out I need to create a different stored procedure.

Thanks again,

James

>Take a look at article 'Using ADO and Visual FoxPro 6.0 to Access SQL Server 7.0 for Primary Key Generation' at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxtk00/html/ft00l1.asp
>
>>Hi,
>>
>>I'm using ADO 2.6 from within VFP6 SP5 and am having a problem getting a record set to be returned from an ADO command object when executing a stored procedure on SQL Server 7. Here is my code:
>>
>< SNIP >