Case Sensitive Database Problem

[Avadhoot]

Hi All,
I've a database created in MS-SQL Server.
I want to make this database Case-Sensitive from COMMAND PROMPT only for some reasons.
I am not able to find the way for the same.
Can anyone tell me how to make MS-SQL database case sensitive from DOS (command) prompt?

Thanks in advance.

Avadhoot

[skhanal]

Can you explain further?. What you are trying to achieve in command line?.

You can change the collation of database to make it case sensitive but it will make it case sensitive from everywhere (query analyzer, ado, etc).

[Avadhoot]

situation is something like this...
I'vce created a database called YUKONTEST in Yukon (SQL 2005)
I can make it case sensitive using GUI however for some test automation I want to make entire database CaseSensitive from command line.
Is it possible? Or what way should I follow? Or do I need to seacrh any specific API for the same?

[skhanal]

You can run

alter database <DBNAME> collate <COLLATIONNAME>

using OSQL from command line.

[Avadhoot]

thanks Very Much
OSQL utility worked out..
I used
osql -E -Q "alter database TESTDB collate SQL_Latin1_General_CP437_CS_AS"

& It worked out !!!
Thanks again,....

Avadhoot