InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 19:46:04 GMT20http://www.sqlservercentral.com/Forums/Topic496210-5-1.aspxhi folksI’ve had a SQL 2000 server restored (using Veritas 9.1) to another server also running SQL 2000. I now have a collation problem.When trying to add users to a database, I receive a "Error 446: Cannot resolve collation conflict for equal to operation" message.I noted that tempdb and user tables collation don’t match - so I was going to change the user tables. However, the master collation doesnt match tempdb, model or msdb. Server is set to SQL_Latin1_General_CP1_CI_ASMaster - SQL_Latin1_General_CP1_CI_AStempdb, model, msdb - Latin1_General_CI_ASI was under the impression that when tempdb was recreated it inherited the master database's collation? This doesn’t seem to be happening.any ideas?much appreciatedN.Wed, 07 May 2008 05:35:12 GMTnjw