posted 1/8/2011 by sqlscottgleason - Views: [1064]
I do a lot of builds during the week and once in a blue moon, I select the wrong collation setting
But thats not an issue with the following script that will rebuild the master database.
Just replace the [] brackes with you own path and set a very strong SA password.
start /wait [path to your sql 2005 sofwtare]\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[Enter a very stong passwrod here] SQLCOLLATION=SQL_Latin1_General_CP850_BIN
Use this
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[Enter a very stong passwrod here] SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI The /qb switch will show warnings.
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[Enter a very stong passwrod here] SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI
The /qb switch will show warnings.