Changing SQL 2005 collation does not require a total re-install. Instead the following can be done :
1. Backup all user databases
2. Drop user databases
3. Make sure security is SQL Server
4. Rebuild the master database as follows :
cd "\Program Files\Microsoft SQL Server\90\Setup Bootstrap"
setup.exe /q /ACTION=RebuildDatabase /INSTANCENAME=MSSQLSERVER /SAPWD="sa-pwd" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /SqlCollation=Latin1_General_CI_AS
More details are here
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment