to do this:
- detache all database
- copy the mdf & ldf files
- go SQL-Server CD--> setup folder
- run : setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=xxxxx SQLCOLLATION=
- attach the databases again
Monday, March 2, 2009
How to change the SQL Server 2005 - Engin Collation
it's easy to change the database collation by using alter database but must of the time we want to change the sql-engin collation.
to do this:
to do this:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment