Changing the clollation settings for MASTER DB

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Changing the clollation settings for MASTER...

Changing the clollation settings for MASTER DB

Rate Topic

Display Mode

Topic Options

Author

Message

santhosh411

Posted Thursday, August 30, 2012 4:57 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:28 AM
Points: 21, Visits: 170

Please tell me how to change the database collation settings for master DB

Post #1352107

rfr.ferrari

Posted Thursday, August 30, 2012 6:06 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:51 AM
Points: 1,219, Visits: 13,507

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

spaghettidba

Posted Thursday, August 30, 2012 6:36 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 8:29 AM
Points: 4,804, Visits: 8,067

Another possible option: http://spaghettidba.com/2011/05/26/changing-server-collation/

Get your two-cent-answer quickly
The Spaghetti DBA

Post #1352155

« Prev Topic | Next Topic »

Permissions