Home Forums SQL Server 2008 SQL Server 2008 Administration Changing database to Read_Write RE: Changing database to Read_Write
dbafromthecold@gmail.com
SSChampion
Points: 10160
More actions
January 29, 2013 at 1:09 pm
#1582339
No worries, good link
http://blog.sqlauthority.com/2010/03/17/sql-server-difference-between-rollback-immediate-and-with-no_wait-during-alter-database/
Summary
No Wait - will cause the statement you are executing to fail if there are open transactions
Roll back Immediate - will rollback open transactions when you execute your script (an override I guess)
Andrew