Script to Change collation setting of a Sqlserver2008

Posted: March 30, 2011 in Sqlserver

Please run the below code from Cmd prompt to change the server level collation for Sqlserver2008.

start /wait \\server\d$\ms_sql_install\ms_sql2008_standard\cd1\setup.exe /QUIET

/ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=Domain\adminxxxx

/SAPWD= Test /SQLCOLLATION=SQL_Latin1_General_CP1250_CI_AS

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s