SQL Server 2005 Resources

Msg 468, Level 16, State 9, Procedure Community_SectionsGetChildSections, Line 24
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.


I was trying to setup "Community Advanced Starter Kit" on my computer for the first and when I am running SQL Scripts proviede with it on SQL Server 2005, keept getting the above error message. Then I have researched on it and found following:

-- There is some but winting SQL 2005 with "collection"

So, I have used SQL Server 2000 instead and scripts worked fine