TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Abhishek Yadav
NA
5.3k
3.3m
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.
Reply
Answers (
3
)
Database Diagram
Required information for L3 level SQL DBAs