I have a hosted SQL Server I'm updating a table by running a SQL UPDATE via ADO. 50 rows, updating row-by-row from an Excel sheet. No problem there.
I just noticed that it takes a second for two for the table to actually update. That's no problem either. BUT immediately after the update I have a SELECT statement so that the update is immediately confirmed on the Excel sheet by the SELECT.
On my local PC it works great. But on the hosted server, because of the 1-2 second delay in the table actually updating the confirmation SELECT is getting the pre-update data. So it 'looks as if' the table didn't update :(
Is it possible to get a 'notification back from the SQL Server' so that I can have a Message Box saying "Done"? (then I can follow it with the confirmation SELECT)