• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 790
  • Last Modified:

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
  • 2
2 Solutions
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...

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now