InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 22:59:15 GMT20http://www.sqlservercentral.com/Forums/Topic1412663-1550-1.aspxNo worries, good linkhttp://blog.sqlauthority.com/2010/03/17/sql-server-difference-between-rollback-immediate-and-with-no_wait-during-alter-database/SummaryNo Wait - will cause the statement you are executing to fail if there are open transactionsRoll back Immediate - will rollback open transactions when you execute your script (an override I guess)AndrewTue, 29 Jan 2013 13:09:20 GMTAndrew Pruskihttp://www.sqlservercentral.com/Forums/Topic1412663-1550-1.aspx[quote][b]Andrew Pruski (1/29/2013)[/b][hr]Would [WITH ROLLBACK IMMEDIATE] help?Andrew[/quote]Thanks Andrew. This worked. I'll read further on ROLLBACK IMMEDIATE.Tue, 29 Jan 2013 13:02:33 GMTsunny.tjkhttp://www.sqlservercentral.com/Forums/Topic1412663-1550-1.aspxWould [WITH ROLLBACK IMMEDIATE] help?AndrewTue, 29 Jan 2013 06:48:36 GMTAndrew Pruskihttp://www.sqlservercentral.com/Forums/Topic1412663-1550-1.aspxYou could add "WITH NO_WAIT"Mon, 28 Jan 2013 14:44:34 GMTarnipeturssonhttp://www.sqlservercentral.com/Forums/Topic1412663-1550-1.aspxI've a read-only database and I'd like to change it to read_write but the following script never seems to complete. Not sure where I'm going wrong.USE DatabaseNamegoALTER DATABASE [DatabaseName] SET READ_WRITE GOIs there an alternative method?Mon, 28 Jan 2013 14:36:43 GMTsunny.tjk