Sql 2008 Errpr

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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=468&LinkId=20476




Thank You
Who is Participating?
Daniel WilsonCommented:
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.
Daniel WilsonCommented:
oops, I omitted the COLLATE keyword in the second statement!
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...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.