Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SPS 2003 + SQL 2005 collation settings?

  Asked By: Nichole    Date: May 12    Category: Sharepoint    Views: 867

If you are using SQL2005 what collation settings are configured? I
can't find what Microsoft supports with SQL 2005 but they have the
following for SQL2000: http://support.microsoft.com/kb/832814/



2 Answers Found

Answer #1    Answered By: Damon Garner     Answered On: May 12

I've not done SQL 2005 with SharePoint 2003 but I'd be surprised if it
isn't the default collation sequence. I've heard that you can achieve
substantial performance gains by moving to it.

Answer #2    Answered By: Christop Mcfadden     Answered On: May 12

our SPS (piloted in the next few weeks) implementation uses a SQL collation of Latin1_General_CI_AS_KS_WS for all four dbs

Didn't find what you were looking for? Find more on SPS 2003 + SQL 2005 collation settings? Or get search suggestion and latest updates.