collation name

hello all,
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
clem and cyrilleTo change the default collation at that stage, you must first export all user data, recreate all database objects, and reload all user data.

Originally posted by clem
hello all,
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
clem and cyrille|||From SQL 2000 you can define the collation settings on database/table/column levels, refer to BOOKS ONLINE for more information COLLATION topic.sqlsql