• 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

------------------------------
ADDITIONAL INFORMATION:

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

------------------------------
BUTTONS:

OK


------------------------------

Thank You
0
jajen
Asked:
jajen
  • 2
2 Solutions
 
Daniel WilsonCommented:
Look at case 3 under remarks here:
http://msdn.microsoft.com/en-us/library/ms184391.aspx

Then look at doing something like:
Select MyCol Collate Latin1_General_CI_AS_KS_WS from SomeTable
UNION
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.
0
 
Daniel WilsonCommented:
oops, I omitted the COLLATE keyword in the second statement!
0
 
onedreamerCommented:
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...
0

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