Posts by Túlio • 1 point

• 0

  votes

  1

  answer

  528

  views

  A: Lock registry (lock) in SQL Server

  Solved, besides changing the table index to not allow lock per page (alter index Myindex on Mytable set (allow_page_locks = off), I removed a field that was filled by a Trigger and it worked.

  sql sql-server delphi

  answered 6 years, 4 months ago Túlio 1

• 0

  votes

  1

  answer

  528

  views

  Q: Lock registry (lock) in SQL Server

  Using SQL Server and Delphi, I need to control so that in a certain database table two changes cannot be made at the same time in the same record, I cannot start the update if there is already…

  sql sql-server delphi

  asked 6 years, 4 months ago Túlio 1