Helps operations that may have to be retried.
sp_iqmpxretryexec( IN _cmd VARCHAR(1024), IN _msg VARCHAR(1024) )
Executes a command, retrying up to 10 times if there is a lock conflict (SQLSTATE 42W18). Catches and logs all errors to the server log.
Column name |
Description |
---|---|
_cmd |
SQL statement to execute |
_msg |
Text to place in error message, if any |