Change collation of MSSQL database

[RFH Reseller: Jaro]

One of my customers asked me the question whether it's possible to change the collation of a MSSQL database to:

SQL_Latin1_General_CP1_CI_AS

Can he (or I) do this himself (i.e. using ALTER DATABASE) or do I need the help of RFH for this?

The origin of his question is that he wants to move a database from another server to RFH and he expects problems with his logfile if the collation is not identical to the one he uses now.

Does this make sense?

[RFH Reseller: Sol]

You should be able to change the coallation using the ALTER DATABASE command since you would have a db_owner role. You can find more info here:

http://msdn.microsoft.com/en-us/libr...4(SQL.80).aspx

[RFH Reseller: Jaro]

Thanks, Sol. I'll have a look.