Hello all....
I am in the process of changing all of the collation to SQL_Latin1_General_CP1_CI_AS.
I have backed up all databases, and uninstalled SQL Server 2005. I then reinstalled SQL Server 2005, setting the server collation to SQL_Latin1_General_CP1_CI_AS.
The user databases have been restored and are accessible by all applications.
If I try to view the properties of any database (system or user), I get the following error:
*********************************************************************************************************************************
TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. (Microsoft SQL Server, Error: 468)
****************************************************************************************************************************************
I have tried executing the "Alter Database [dbname] Collate SQL_Latin1_General_CP1_CI_AS" procedure, but that does seem to help. Does anyone have any ideas?
Thanks,
Forch
What is the collation or all the databases?
run select * from sys.databases.
How did you restore the databases, backup/restore, attach/dettach?
|||Master is SQL_Latin1_General_CP_C1_AS, and the rest of the system dbs is Latin1_General_CI_AI. The user dbs are evenly divided between the 2.
I can't remember how I restored.... it was probably backup / restore.
Thanks,
Forch
|||Hi Forch,
Probably the backed up databases have the old collation, but the SQL server system databases have the new collation.
You can do:
ALTER RESTORED_DATABASE { COLLATE SQL_Latin1_General_CP1_CI_AScollation_name }
to change the collation of the restored databases to the new collation
Cheers
|||Have you tried to access the database from the query analyzer too?