October 7, 2009 at 2:41 pm
I have SQL Server 2005. In the Management Studio, when I click on database properties, I receive the following error: Cannot Show Request Dialog --Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in the equal to operation.(Microsoft SQL Server, Error: 468).
Worked Fine last week, nothing has changed...help please!
October 7, 2009 at 3:20 pm
Hi j,
I can't believe nothing has changed. I may be wrong, but the message points to the fact that the collation of the server itself and the database you are attempting to get the properties from are incompatible (Accent Sensitive = AS versus Accent Insensitive = AI). Did you restore/attach the database that came from some other server? What's the collation of the server? SSMS may well be doing something in the background that forces data into tempDB, which automatically has the same collation sequence as the server.
Regards,
Jan
October 7, 2009 at 3:35 pm
Thanf for your answer,
masterSQL_Latin1_General_CP1_CI_AS
tempdbSQL_Latin1_General_CP1_CI_AS
model SQL_Latin1_General_CP1_CI_AS
msdb SQL_Latin1_General_CP1_CI_AI
cinfo SQL_Latin1_General_CP1_CI_AS
db1 SQL_Latin1_General_CP1_CI_AS
db2 SQL_Latin1_General_CP1_CI_AS
Server:
SQL_Latin1_General_CP1_CI_AS
I cant even see the properties of system databases
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply