Sql 2008 Errpr

Posted on 2011-10-03
Last Modified: 2012-06-13
I am receiving the following error when I click on a login and click through the list of items in the select a page when I click on the Securables option.  If I open the login name and click directly on the Securables option I do not get the error.  Can you please let me know how to fix.

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click:


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


Cannot resolve the collation conflict between "Latin1_General_CI_AS_KS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the UNION operation. (Microsoft SQL Server, Error: 468)

For help, click:




Thank You
Question by:jajen
    LVL 32

    Accepted Solution

    Look at case 3 under remarks here:

    Then look at doing something like:
    Select MyCol Collate Latin1_General_CI_AS_KS_WS from SomeTable
    Select MyOtherCol Latin1_General_CI_AS_KS_WS from AnotherTable

    Open in new window

    Basically, you're forcing a collation change, kind of like you would force a type change with a CAST statement.
    LVL 32

    Assisted Solution

    by:Daniel Wilson
    oops, I omitted the COLLATE keyword in the second statement!

    Expert Comment

    This is not the answer I excpected.

    The error occured in the login properties page when I click on "Securables" just after clicking "User Mappings".

    Workaround I just discovered it:
    When I click on "Securable" first when the login properties page is loaded the error message is not displayed, I guess the error does not happen.
    Any way...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now