Change the server Collation
-
Hi.
How can I change the collation of the server in SQL Server 2008?
Thanks.
. .
We, Iranians: "The Peaceful Nuclear Energy is our indisputable right." -
You need to rebuild the master database in order to change the server collation.
http://technet.microsoft.com/en-us/library/ms179254.aspx
[font="Verdana"]Markus Bohse[/font]
-
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=SQL_Latin1_General_CP1_CI_AIWhen I run this command (the dvd of Sql 08 is in drive i.e G:) an error occures like this:
. .
We, Iranians: "The Peaceful Nuclear Energy is our indisputable right." -
Your problem is because the syntax in the KB article is wrong.
During the SQL Server 2008 development process, the syntax for setup.exe was changed and all keywords must now start with /, so try
The article http://blogs.msdn.com/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx has the correct details.
The syntax is initially parsed by the old DOS commpand processor, so you may need to put some of your values in quotes (e.g. /SAPWD="needs-quotes")
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
-
The article http://blogs.msdn.com/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx has the correct details.
Thanks a lot.
My problem was solved with that article.
. .
We, Iranians: "The Peaceful Nuclear Energy is our indisputable right."
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply