2

With TRANSACTION, is there a way to have it ROLLBACK automatically after X number of seconds? This way you'd prevent accidentally leaving a TRANSACTION open and locking the database.

Kellen Stuart
  • 7,775
  • 7
  • 59
  • 82

1 Answers1

3

get Tools>properties >Designers > table and data base designers --- then set "transaction time-out after" upper than 90s or more than. Tools>properties

Amirhossein
  • 1,148
  • 3
  • 15
  • 34
  • Does this perform a `ROLLBACK` if the time is exceeded? – Kellen Stuart Sep 13 '19 at 19:08
  • 1
    you have two way. 1. set time by second... (If the execution is not complete and finish time for query is rollback) 2.you can set none time (isn't recommend) Unchecked "Override connection string time-out value for table designer update" --- not rollback for unlimited (automatically- you can stop manually or use wait function in query ) – Amirhossein Sep 14 '19 at 05:13