Tuesday, November 6, 2012

What is Difference between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE?




ROLLBACK AFTER integer [SECONDS] | ROLLBACK IMMEDIATE:

Specifies whether to roll back after a specified number of seconds or immediately if transaction is not complete.
...

NO_WAIT:

Specifies that if the requested database state or option change cannot complete immediately without waiting for transactions to commit or roll back on their own, then the request will fail.

(Read more here http://bit.ly/sql-interview)

No comments:

Post a Comment