To do it use the following query:

ALTER DATABASE database_name COLLATE collation_name

you can get current collation and other properties of database by the
following query:
sp_helpdb database_name

© 2007 The Planet, Inc. All rights reserved. The Planet, and the Planet logo are registered trademarks or service marks of The Planet, Inc. All other trademarks listed in this document are the property of their respective owners. The company names or names of products of other companies mentioned in this document, if any, may be the registered or unregistered trademarks of the owners of the products.