Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

One of our production SQL 2000 server has windows collation for master and msdb but SQl collation for model and tempdb. We are trying to have the same setup on a test environment which at the moment has windows collation for all system databases So, I got a copy of the model database with SQL collation from another server and did the following:

  1. restored it as another user database (model2).
  2. shut down the SQL service
  3. moved the model database files (model.mdf and modellog.ldf) to another location
  4. Renamed model2 database files as model.mdf and modellog.ldf so that SQL will think that this is the existing database.

It did change the collation but when I right click on model database and click on shows the following error:

"Cannot resolve collation conflict for equal to operation"

Which it doesn't show in the existing production server.

Please help Regards


share|improve this question

I was restoring database using management studio and not enterprise manager. I could restore model using enterprise manager without any problem.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.