Re: Master Database Collation issue
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/28/04
- Next message: Rick Sawtell: "Re: Convert Char Value to Datetime Value"
- Previous message: Tibor Karaszi: "Re: Transaction Logs"
- In reply to: kalamos: "Master Database Collation issue"
- Next in thread: Sasan Saidi: "RE: Master Database Collation issue"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 28 Oct 2004 21:29:02 +0200
> The question is how do I change master, tempdb, model etc from their existing
> SQL_Latin1_General_CP1_CI_AS to Latin1_General_CI_AS ?
Read about rebuildm.exe, but note that it will scratch your system databases.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "kalamos" <kmcclare@hotmail.com> wrote in message news:10o2hao690h096e@corp.supernews.com... > Let me start from the beginning. > > SqlServer was installed with default settings which meant: SQL_Latin1_General_CP1_CI_AS > Later a third part application was added that created a database with this collation: > Latin1_General_CI_AS > According to the vendor SqlServer should have been installed with the Latin1_General_CI_AS > collation settings. > > The question is how do I change master, tempdb, model etc from their existing > SQL_Latin1_General_CP1_CI_AS to Latin1_General_CI_AS ? > > One solution was to install another instance of sqlserver with the proper collation and just copy > these databases over the ones that are in error. > Bring up the server and "Business as Usual". > > Will this work? It seems to. What failures can we expect? > tks > ken.mcclaren@charter.net > > > >
- Next message: Rick Sawtell: "Re: Convert Char Value to Datetime Value"
- Previous message: Tibor Karaszi: "Re: Transaction Logs"
- In reply to: kalamos: "Master Database Collation issue"
- Next in thread: Sasan Saidi: "RE: Master Database Collation issue"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
