>I would like to be able to update a progress bar with the status of a SPT statement. The data is on SQL Server being accessed via ODBC. We are using Remote Parameterized Views but of course don't want to / can't bring down the whole table to perform functions locally but have to show the status of the Select, Update, Delete.
>
>I've looked at getting @@rowcount and from SQL Server but that returns the total affected and only executes after the previous statement is done.
>
>@@cursor_rows returns the number of rows currently in the keyset but again, only executes after the previous statement has completed.

There is nothing I know that will do this because SQL Server is processing your request. In order to have it return anything before this, you would have to create another connection and run another process to get the status. FWIW, sp_who "userID" will give you some (but not much) status information about what is going on.

You could take alook at the help topic "asynchronous batch processing mode". You could create you own progress function using the techinques explained there.

HTH.