Geeks With Blogs

My Techie Blog Knowledge Creation is Essential to Business, and Communication is Essential to Knowledge Creation April 2010 Entries
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
I was writing a store proc for a report and i needed some data from another server so i added a linked server to connect to this new db server. when i do a select like below its all fine select a,b,c from Server.DatabaseName.dbo.table But when i use the table in a join i get the error "Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation." I did check the collation set on the 2 databases and it was actually the same and ......

Posted On Friday, April 30, 2010 12:34 AM

Useful Sharepoint 2010 Resources

Cam across this materials for sharepoint  2010 on Shailen Sukul's blog.
Very resourceful i must say.

Posted On Thursday, April 22, 2010 10:11 PM

Free MSDN Magazine

Just surfed on this Free MSDN Magazine sweet

Posted On Thursday, April 22, 2010 10:05 PM

SharePoint 2010 Launch

Some great news for sharepoint developers,architect,consultants etc...

May 12, 2010 is the official release date for SharePoint 2010 & Office 2010. Also, Microsoft announced their intent to RTM (Release to Manufacturing) for April 2010.

read more here

Posted On Wednesday, April 21, 2010 6:24 AM

Copyright © Patrick.O. Ige | Powered by: | Join free