Master Database Collation issue

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: kalamos (kmcclare_at_hotmail.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 15:15:36 -0400

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

Relevant Pages

  • RE: How to prevent remote debugging?
    ... I did import the VS2008 settings from the working computer but still the ... Computer A - Application Server running Third Party Service. ... the Server tools but only to install the SQL Server 2005 database. ... SQL database also running but the Computer A is now pointing to Computer B) ...
    (microsoft.public.vsnet.debugging)
  • Re: Help required
    ... I don't think anyb ody sayd you were too stupid to use SQLServer in any way, ... and I was told that I am too stupid to use it so I just got rid of it and thus I can not use SQL Databases. ... Once again when I tried to used the SQL Database in my project I got the same error message about SP_INSTANCE ... Download SQLServer Express Management Studio and install it. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: default login - mysqld 4 on rhel 4
    ... > I installed the mysqld on a rhel 4 and i want to login to the database ... > to change some settings but I cant. ... There shouldn't be a default password in a fresh install... ...
    (RedHat)
  • Re: Trouble installing SP2
    ... Failed to install catalog files. ... > creates a new database.) ... > creates a log file and prompts you for the location of the log file. ... > After restoring the default settings, ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Multiple database support
    ... The only thing I do not like is that it requires you to perform an install ... >> How do most people support multiple database types such as SQLServer, ...
    (microsoft.public.dotnet.framework.adonet)