Quickest way to change Collation of Master DB?

From: Fred Morrison (anonymous_at_discussions.microsoft.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 13:08:29 -0700

I need to change the collation of the Master database on
my (local) server to Latin1_General_CP1_CI_AS.

What's the quickest, painless way to do that?

Relevant Pages

  • Re: SQL 2000 server TCP bind problem
    ... If so then some other service grabbed port 1433 before SQL ... Server did. ... You can restore a backup of the master database if needed. ... There is also a utility to rebuild the master database ...
    (microsoft.public.sqlserver.connect)
  • Re: Access denied after OS Disk upgrade!?
    ... Hardware problems can also cause recovery failures. ... you may see error messages similar to the ... RTM version and is not supported by this server. ... that SQL Server was unable to recognize this file as a valid master database ...
    (microsoft.public.sqlserver.connect)
  • RE: Disconnected Database Solution.
    ... > while disconnected from the main database (SQL Server ... > directional upload/download new information since last ... Are there any such features available in SQL ... > Server level I can synchronize with the master database ...
    (microsoft.public.sqlserver.programming)
  • RE: Disconnected Databases on Laptops
    ... in case you will be targeting smaller compact devices like pocket PC try ... > while disconnected from the main database (SQL Server ... > Server level I can synchronize with the master database ...
    (microsoft.public.sqlserver.ce)
  • Re: login failed for user username
    ... Since the Master database holds the login information, ... Master database, if not you have move the logins atleast to new server. ... > In the SQL Server log there is a message Login failed for user 'username'. ...
    (microsoft.public.sqlserver.server)
Loading