![SQL 2005](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGkukiAmtBdftBNLnTzDV0C7DrEfhFkdL8PhIO_k2sqfqZowwiB0VRM_kUv97O9-on5EMmHFl7Hi73XsQptwQhPE6mTXo2JN2rvblWMvdnQDMAqkgi3c1O76fEp-F9qRkeonUq/s320/SQL_2005.jpg)
When you try to change it into SQL 2005, you get the error:
Cannot alter the database 'model' because it is a system database. (Microsoft SQL Server, Error: 3708)
This occur because all system databases (including model and tempdb) must have the same collation as master. Mmmmmmm to change tempdb, I must change model, but to change model, I've to change master !!
In earlier version the REBUILDM.EXE could do thework well, how can I do it in SQL 2005 ?
Step 1. Put SQL Server into Single User Mode (use “sqlserver.exe -m” )
Step 2. Rebuild the system databases (start /wait setup.exe /q INSTANCENAME=
Step 3. Restart the SQL Server Services in regular mode
Before do it, read here:
http://msdn2.microsoft.com/en-us/library/ms179254.aspx !!!
0 commenti:
Post a Comment