Select Page

Dropping a subscriber database

Usually I can simply run an ALTER statement against the database and SET SINGLE_USER WITH NO_WAIT like so: ALTER DATABASE MyDBName SET SINGLE_USER WITH NO_WAIT but I ran into a problem with active processes that prevented me from switching to SINGLE_USER mode. So I...