title: Change SQL Server 2005 Server Collation
body: <p>I need to set up an instance of SQL Server 2005 with SQL_Latin1_General_CP850_Bin as the server collation (the vendor did not take into accounting looking at DB collation for a bunch of things so stored procedures and temp tables default to the server level and the default collation will not work). During the install for SQL Server it did not give that as an option so I left it at default and finished installing it.</p>
  
  <p>According to <a href="http://msdn.microsoft.com/en-us/library/ms179254.aspx" rel="nofollow noreferrer">MSDN</a> and <a href="http://technet.microsoft.com/en-us/library/ms179254.aspx" rel="nofollow noreferrer">Technet</a> I should need to just run the following command:</p>
  
  <pre><code>setup.exe /q /ACTION=RebuildDatabase /INSTANCENAME=MSSQLSERVER /SAPWD="sa-pwd" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /SqlCollation=SQL_Latin1_General_CP1_CI_AI
  </code></pre>
  
  <p>However, whenever I run the above command with my parameters I get the pop-up of the SQL Server installation wizard, accept the agreement, and then it gives me output stating how to use the command.</p>
  
  <p>Any idea what I can do?</p>