I have a vb application which updates a record in a table in a SQL db. However, when I have 2 machines updating the same record at the same time it simply seems to cancel each of the requests out!!!
The vb code is using a stored procedure, is there a way i can make the stored procedure execute straight away!!! within in miliseconds? As at the moment it doesn't seem to be updating at all when both machines do it at the same time.
Cheers for any help!
The vb code is using a stored procedure, is there a way i can make the stored procedure execute straight away!!! within in miliseconds? As at the moment it doesn't seem to be updating at all when both machines do it at the same time.
Cheers for any help!
