• 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