Shashank Srivastava (SQL DBA)

Hi all, I am Shashank Srivastava currently working as a SQL DBA for a client that has one of the best database environment in the world. I have two years of experience and just wanted to learn and share through the blog. This blog is just to share my knowledge with all the people and learn from them. I have completed Microsoft Certified Technology Specialist -MS SQL SERVER 2005 , Microsoft Certified Technology Specialist -MS SQL SERVER 2008 and ITIL v3 Certified IT professional certifications.

Tuesday, September 11, 2012

How to change the collation of the server.

Run the below command in CMD and it will change the collation of the server. Master database will be rebuild.

setup.exe /Quiet /ACTION=REBUILDDATABASE /INSTANCENAME=Instance2 /SQLSYSADMINACCOUNTS=server\Administrator /SAPWD=sa123 /SQLCOLLATION=SQL_Latin1_General_CP1_CS_AS

Shashank Srivastava (SQL DBA)

MCITP

Tuesday, September 11, 2012

How to change the collation of the server.

No comments:

Post a Comment

Followers