Improve company productivity with a Business Account.Sign Up

x
?
Solved

AUTO_CLOSE & collation_name

Posted on 2013-11-12
1
Medium Priority
?
426 Views
Last Modified: 2013-11-13
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?
0
Comment
Question by:25112
1 Comment
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 2000 total points
ID: 39643644
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

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question