Changing SQL Server Collation After Installation

I had a necessity to change the collation of newly created SQL server instance from CI_AS to CP1_CI_AS. To brief you about why this was needed, I wanted to test upgrade GP from version 2010 RTM to 2010 SP3. In order to that, I created a new SQL server instance with collation SQL_Latin1_General_CI_AS. I restored GP 2010 RTM backups on to this newly created server. But later realised that GP databases that I got for 2010 RTM was of collation SQL_Latin1_General_CP1_CI_AS. There were two options ...read more
Related
Recommended