Take a look at Re: Can stored procedures return values? Message #876903
>
>How do I code my stored procedure in SQL server 2000 so that
>I can retrieve whether the record is updated, replaced or deleted
>and how many records affected by the SQL command by my VFP6 application who
>call this procedure ?
>
>Please assist with code example in SQL and VFP.
>
>Thank you