sql server 2005 排序规则与大小写敏感

If you installed; Sql Server 2005; Full; !

When Your Run Follow:--------------------------------use AdventureWorksgoselect * 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.

ANDThere 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'.