Thanks, the ASYNC option is False though.

We can handle the occasional issue, but it is perplexing.

We keep our websites running while we switch out the database so there is always the 'possibility' that a new connection will be made immediately AFTER we kill user connections...however...

SQL SERVER does not allow the following in a transaction so how would this work?

ALTER DATABASE oldName MODIFY NAME = newName

We have a messy system to replace a database at...