SQL Server 2005：选择数据库属性时的排序规则冲突错误 [英] SQL Server 2005: Collation Conflict Error when selecting Database Properties
问题描述
我刚从SQL Server 2000升级到SQL Server 2005.
在Microsoft SQL Server Management Studio中，当我点击数据库
属性时，我收到以下错误： -
无法解决
" Latin1_General_CI_AS"
和SQL_Latin1_General_CP1_CI_AS之间的整理冲突等于操作。
（Microsoft SQL Server，错误：468）
一些参考建议我可以通过
更改数据库排序规则
点击数据库属性！
我该怎么办？
I have just upgraded to SQL Server 2005 from SQL Server 2000.
In Microsoft SQL Server Management Studio, when I click on database
properties, I receive the following error:-
Cannot resolve the collation conflict between
"Latin1_General_CI_AS"
and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
(Microsoft SQL Server, Error: 468)
Some reference suggest that I can change the database collation by
clicking database properties!
What can I do?
推荐答案
Peter Nurse（Pt****@yahoo.com.au）写道：
Peter Nurse (Pt****@yahoo.com.au) writes:
我刚刚从SQL Server 2000升级到SQL Server 2005.
在Microsoft SQL Server中管理工作室，当我点击数据库
属性时，我收到以下错误： -
无法解决
Latin1_General_CI_AS
和/之间的整理冲突SQL_Latin1_General_CP1_CI_AS"等于操作。
（Microsoft SQL Server，错误：468）
有些参考资料表明我可以通过单击数据库属性来更改数据库排序规则！
我该怎么办？
I have just upgraded to SQL Server 2005 from SQL Server 2000.
In Microsoft SQL Server Management Studio, when I click on database
properties, I receive the following error:-
Cannot resolve the collation conflict between
"Latin1_General_CI_AS"
and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
(Microsoft SQL Server, Error: 468)
Some reference suggest that I can change the database collation by
clicking database properties!
What can I do?
闻起来像臭虫。但问题是：你是怎么到达这里的？
如果我理解正确，你有一个SQL 2000实例，你升级到了
SQL 2005？
SQL 2000中有哪些服务器排序规则？你升级时选择了不同的
整理吗？
你是否对所有数据库都有这个错误，或者只有一些？
您可以尝试安装SP1的CTP，以查看问题
是否已解决，尽管我的直觉表明它不是。你在这里找到了
CTP：
http：// www .microsoft.com / downloads / i ... splayLang％3den
-
Erland Sommarskog，SQL Server MVP， es **** @ sommarskog.se
SQL Server 2005联机丛书
http://www.microsoft.com/technet/pro ... ads / books.mspx
SQL Server 2000联机丛书
http://www.microsoft.com/sql/prodinf...ons/books.mspx
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?
What server collation did you have in SQL 2000? Did you select a different
collation when you upgraded?
Do you get this error with all databases, or only some?
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:
http://www.microsoft.com/downloads/i...splayLang%3den
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
感谢您的帮助，Erland。
Thanks for your help, Erland.
闻起来像个臭虫。但问题是：你是怎么到达这里的？
如果我理解正确，你有一个SQL 2000实例，你升级到了SQL 2005？
是的，我从SS 2000升级。我没有使用升级顾问，因为
要么1）我不知道它在那里还是2）它没有好好工作。我忘记了哪一个。
你在SQL 2000中有什么服务器整理？升级后，您是否选择了不同的
排序规则？
我从未有意识地选择整理。我不知道他们
直到SS 2005！
你是否对所有数据库都有这个错误，或者只有一些？
所有数据库，包括Northwind&掌握了我没有触摸的b $ b $
您可以尝试安装SP1的CTP，看看问题是否已解决，尽管我的直觉表明事实并非如此。你在这里找到了
CTP：
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!
Peter Nurse（Pt****@yahoo.com.au）写道：
Peter Nurse (Pt****@yahoo.com.au) writes:
你是否对所有数据库都有这个错误，或者只有一些？
Do you get this error with all databases, or only some?
所有数据库，包括Northwind&没有我曾经触摸过的主人。
All databases including Northwind & Master neither of which I''ve
touched.
你可以运行这个并发布输出：
从sys.databases中选择name，collation_name，compatibility_level
select serverproperty（''Collation''）
假设所有数据库都处于模式80，请尝试运行
" sp_dbcmptlevel Northwind，90"看看这是否有所改变。
-
Erland Sommarskog，SQL Server MVP， es****@sommarskog.se
SQL Server 2005联机丛书
http://www.microsoft.com/technet/pro...ads/books.mspx
SQL Server 2000联机丛书
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Could you run this and post the output:
select name, collation_name, compatibility_level from sys.databases
select serverproperty(''Collation'')
Assuming that all databases are in mode 80, try running
"sp_dbcmptlevel Northwind, 90" and see if this changes anything.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
这篇关于SQL Server 2005：选择数据库属性时的排序规则冲突错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
