Server and user databases using different collations

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Server and user databases using different...

Server and user databases using different collations

Rate Topic

Display Mode

Topic Options

Author

Message

Fishbarnriots

Posted Tuesday, June 08, 2010 6:33 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 8:14 AM
Points: 237, Visits: 1,754

Hi,

I have managed to end up with a server and its' system databases using Latin1_General_CI_AS and the user databases using SQL_Latin1_General_CP1_CI_AS.

All other servers use SQL_Latin1_General_CP1_CI_AS for system and user databases, so this would be out "standard".

Is there anyway to change the server/system databases to use SQL_Latin1_General_CP1_CI_AS without affecting the user databases, if possible I want to avoid having to export objects and data from the user databases, drop the dbs and then recreate and reimport the objects and data.

Any help much appreciated.

Post #933952

« Prev Topic | Next Topic »

Permissions