安裝完畢後,修改 SQL Server 2008/2008 R2 執行個體的 Collation

參閱:http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx

簡單的範例

setup.exe /ACTION=REBUILDDATABASE /INSTANCENAME=<執行個體名稱,不需要電腦名稱,若是 Default instance 需指定 MSSQLSERVER > /SQLSYSADMINACCOUNTS=<Windows 帳號> /SAPWD=<若採用的是混和模式,才需要賦予 sa 密碼,否則不要輸入這個選項> /SQLCOLLATION=Chinese_Taiwan_Stroke_CI_AS

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

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

Twitter picture

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

Facebook照片

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

Google+ photo

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

連結到 %s

%d 位部落客按了讚: