Türkçe   |   English
Calendar
Categories
Archive
Links
Blogroll
Files

Changing SQL Server collation - 24.12.2008

While formatting and reinstalling my computer on Sunday, I realized that my SQL Server Collation wasn't installed in Turkish. Since I was incredibly bored of installing programs, I didn't want to uninstall and reinstall SQL Server. I searched the web and found out that there's a way to change the collation of SQL Server. The answer to do this is in the setup.exe in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap folder. When you run the command below in command prompt you can change collation of your SQL Server. Important: There is one thing to remember before running this command: you should back up all your user databases!!!!

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap>start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=pass SQLCOLLATION=TURKISH_CI_AS

Code

19.05.2009 - Jatin P
I have Also face problem like you for SQL Server and Thanks for your suggetion on blog

26.06.2009 - Ashish Singhvi
hi i like ur projects could u provide me more ones..
Add Comment
First Name Last Name
Web Site
E-Mail
Comment
Security Picture

Photos
Me in MSDN Forums
-   Answered the question How can i get it in the Visual C# General forum
-   Answered the question How to add the VAT to the ammount in the Visual Basic General forum
-   Contributed a proposed answer to the question How to add the VAT to the ammount in the Visual Basic General forum
-   Replied to the question How can i get it in the Visual C# General forum
-   Replied to the question How to add the VAT to the ammount in the Visual Basic General forum
-   Answered the question How to show ToolStripMenuItem's hot key? in the Windows Forms General forum
-   Contributed a proposed answer to the question How to show ToolStripMenuItem's hot key? in the Windows Forms General forum
-   Answered the question Expert to Excel Missing Some Data In Grid View in the Visual C# Language forum
-   Contributed a helpful post (total votes:1) to the forums thread Expert to Excel Missing Some Data In Grid View in the Visual C# Language forum
-   Replied to the question How to show ToolStripMenuItem's hot key? in the Windows Forms General forum
Entries
News
Articles