博客园 首页 新随笔 联系 订阅 管理

If you installed  Sql Server 2005  Full  !

When Your Run Follow:
use AdventureWorks
select * from  sales.customer ----it's error!why?
select * from  Sales.Customer----it's right!


This issue is related to your database collation setting.

You can try run this to find out what your database collation is:

SELECT databasepropertyex(AdventureWorks','collation')

The collation of your database makes your query case sensitive.

If you want a quick change,  you can change your database to another collation which is not case sensitive, for examle:

ALTER DATABASE AdventureWorks COLLATE SQL_Latin1_General_CP1_CI_AS

You can search Books online for more information on collation.

There are some limitations on altering collation of a database, maybe there are some SCHEMABINGING views in the database. you can refers to SQL2005 Books Online, and locate:

'ALTER DATABASE (Transact-SQL)' topic ->'Remarks' section->'Changing the Database Collation'.

posted on 2006-04-26 12:23  瓶子  阅读(772)  评论(0编辑  收藏  举报