Abhishek Yadav

Abhishek Yadav

  • 313
  • 5.3k
  • 3.2m

AUTO_CLOSE in SQL Server

Apr 26 2015 6:33 PM
Hello Guys,
 
 Yesterdays I was doing some research  on AUTO_CLOSE option in SQL server, and after reading many articles and blogs, I've one little doubt.
 
95% of those articles said that we've to keep AUTO_CLOSE option OFF for any database in any  environment, we're not suppose to enable this option.
 
So, my question is, if we need to keep this option OFF all the time, then what is the use/purpose of this option??? Why this option is still available  in SQL Server?? In what scenario we enable AUTO_CLOSE??
 
Anyone, please suggest.
 
Thanks and Regards,
 Abhishek Ramjeet Yadav.

Answers (3)