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, July 8, 2014 5:46 AM
Points: 37, Visits: 239
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: Wednesday, July 23, 2014 11:04 AM
Points: 1,256, Visits: 13,552
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:10 AM
Points: 5,018, Visits: 10,526
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