The following databases (all databases on the instance) have is_auto_close_on = 1:īut I don't see repeating messsages about other databases. Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote Thanks, Rama Udaya.K "“You only live once, but if you do it right, once is enough. Inorder to turn of autoclose- USE ĪLTER DATABASE SET AUTO_CLOSE OFF WITH NO_WAIT So might be the connection to the database exists I guess. So usually on Production it is not recommendable at all how ever if you have specific reason knowing the impact in apps. When ever the users is trying to connect to that database with using USE
When the Autoclose is ON on the database, for example one user connected to that database consider he is the last user for that Database from connection point of view,as soon as last user exists the database will be shutdown & it automatically reopens The 1 means currently the Database Autoclose is on