Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Changing the clollation settings for MASTER DB Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 4:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 6:14 AM
Points: 37, Visits: 237
Please tell me how to change the database collation settings for master DB
Post #1352107
Posted Thursday, August 30, 2012 6:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:25 PM
Points: 1,253, Visits: 13,546
well, this article can help you: dd207003

but, the informations in msdb like as job's, alerts, operators will be deleted!!!
others modifications made by users on database master and model will be deleted too.

be careful!



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1352132
Posted Thursday, August 30, 2012 6:36 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:16 AM
Points: 4,930, Visits: 8,744
Another possible option: http://spaghettidba.com/2011/05/26/changing-server-collation/

--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1352155
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse