Changing Collation in SQL Server 2000

Hi.

I don't know how to change the collation in SQL Server 2000, my collation is Modern_Spanish_CI_AS, if somedoby knows the procedure to change the collation I would be thankful.

Thank you again and best regards.

Christian

Hi,

For database, ALTER DATABASE databasename COLLATE collation_name.

Change the order rule of tables, ALTER TABLE TabelName ALTER COLUMN ColumnName varchar(10)COLLATE ordername NOT NULL

Some good links for you to refer:

http://support.microsoft.com/kb/325335
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=60020&SiteID=1

Thanks.