Post reply

SQL Server 2005 Management Studio bug??

  • October 7, 2009 at 2:41 pm

    #134288

    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

    #1063108

    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

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • October 7, 2009 at 3:35 pm

    #1063118

    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