collation name

[clemfrench]

is it possible to change the propertie "collation name" of a database?
if it is not the case can we change the properties of our SqlDataAdapter (object of VisualStudio.net) or other objects?
thanks for responses
bye
cyrille and clem

 

[SQLBill]

ALTER DATABASE mydatabasename COLLATE newcollationname

Refer to the BOL for more information. Use the Index tab and enter COLLATIONS and select 'changing'

-SQLBill