Thanks.

My alternative method, was to back up/export the user databases, delete the instance, create a new instance with the correct collation and then re-create/import the databases.

Does your method achieve the...

Thanks

I have a user database that has been created using the default - do I leave that attached (i.e so that it is changed)?

I have an SQL Server 2005 instance where the default collation is set to Latin1_General_CI_AS, but the user databases are set to SQL_Latin1_General_CPI_CI_AS.

I need to change the default/server collation to...