Post reply

Collation Error 468

  • August 11, 2016 at 12:11 am

    #310389

    Hello All,

    I am having default Collation as Latin1_CP1_CI_AS on my server and databases but when i am trying to open a new query window it is throwing an error

    Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.

    Could not use view or function 'dbo.sysdac_instances' because of binding errors. (Microsoft SQL Server, Error: 468)

    Could anyone help on this please..

    Thanks,

    PrimeSQL

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Save a tree... Please don't waste paper unless you really need to!

    When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'

  • August 14, 2016 at 2:53 am

    #1895344

    info.sqldbamail (8/11/2016)

    Hello All,

    I am having default Collation as Latin1_CP1_CI_AS on my server and databases but when i am trying to open a new query window it is throwing an error

    Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.

    Could not use view or function 'dbo.sysdac_instances' because of binding errors. (Microsoft SQL Server, Error: 468)

    Could anyone help on this please..

    Thanks,

    PrimeSQL

    Is there a database collation difference between primary & secondary

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply