Welcome to our Knowledge Base

Enter your search terms below.

Categories
< All topics
Print

SQL Server Collation

Description of the problem

CreateSteadyDB does not install a new Database and fails with the error “Error installing a new Database: Invalid object name ‚information_schema.columns‘.

 

This error can be encounterd by customers that are not using

COLLATE SQL_Latin1_General _CI_AS.

Most likely this will happen to people from countries that use a different default collation than Latin1. You can see here what’s the default collation for your Operation System when installing Sql Server.

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms143508(v=sql.105)


Solution

To see what collation your SQL server is using you can use SQL Management Studio “Master -> Properties -> Options -> Collation”

Update Collation:
The easiest way is to reinstall SQL Server and choose the Latin1_General_CI_AS.

To change the collation without updating SQL Server we suggest the following Microsoft Knowledge Base https://support.microsoft.com/en-us/help/325335/how-to-transfer-a-database-from-one-collation-to-another-collation-in

It’s important to perform a backup of the Master Table before changing the collation.

Was this article helpful?
0 out of 5 Stars
5 stars 0%
4 stars 0%
3 stars 0%
2 stars 0%
1 stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
btnimage