help me~~about sql server 2005

use AdventureWorks
go
select * from sales.customer --it's error!why?
select * from Sales.Customer--it's right!

how to let sqlserver2005 IgnoreCase ?

This issue is related to your database collation setting.

You can search Books online for more information on collation.

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

|||

THANKS!

but when i run follow:

ALTER DATABASE AdventureWorks COLLATE SQL_Latin1_General_CP1_CI_AS

it throw error and prompt some view ,table etc,depend on the current collation

~~

NOW!HOW CAN I TO DO ?

|||

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

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

help me!beginner create database password

I've learn DotNetNuke.I don't know how to create passID and userID for database sqlserver2005 express.someone help me.Thanks!thanks!You can do that by using the appropiate TSQL command, like sp_AddLogin and so forth, but as a beginner I would suggest you to use the SQL Server Management Express which has a graphical interface to administer the server instance. You will have to create a user and map the user to the appropiate database. There you will have to either grant him a role or dedicated permissions on the securables (objects) within the database.

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

can you help me how step by step I have to do:

right click database(example I've created database name"dotnetnuke")?

then choose properties->choose permissions?

Or can you tell me TSQL command...?

Thank you very much!

|||

I've created new users name"dnnusers" and set some permissions but I've recieved some instructions:

"Grant failed for Database 'DotNetNuke'. (Microsoft.SqlServer.Smo)"why?