You are here: Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties « MsSQL Server « IT news, forums, messages
Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties

Posted by Peter Nurse on 10/06/77 11:43

Thanks for your help, Erland.

>That smells like a bug. But question is: how did you arrive here?
>If I understand it right, you had an SQL 2000 instance that you upgraded to
>SQL 2005?
Yes, I upgraded from SS 2000. I didn't use the upgrade advisor because
either 1) I didn't know it was there or 2) it didn't work properly. I
forget which.

>What server collation did you have in SQL 2000? Did you select a different
>collation when you upgraded?
I've never consciously selected a collation. I didn't know about them
until SS 2005!

>Do you get this error with all databases, or only some?
All databases including Northwind & Master neither of which I've
touched.

>What you could try is install the CTP of SP1, to see if the problem
>is resolved, although my gut feeling says that it is not. You find the
>CTP here:
I think I might defer that until I'm really desperate!

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация