AUTO_CLOSE & collation_name

I had a database whose collation_name came as NULL in sys.databases... when I set the auto_close to off, then the collation_name is back as SQL_Latin1_General_CP1_CI_AS

does auto close affect the collation chosen?
LVL 5
25112Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Paul JacksonConnect With a Mentor Software EngineerCommented:
No, there's a bug/feature in sql server SSMS that the collation_name is returned as null on a database that has been auto_closed maybe that is what happened in your case.
0
All Courses

From novice to tech pro — start learning today.