Welcome: Guest!

Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

SPS 2003 + SQL 2005 collation settings?

  Asked By: Nichole Cole         Date: May 12, 2006      Category: Sharepoint      Views: 221
 

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/

Tagged:            

 

2 Answers Found

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

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, 2006       

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

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


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
Hall of Fame  |  Facebook  |  Twitter  |  LinkedIn  |  Terms of Use  |  Privacy Policy  |  Contact us
RSS Feeds: Articles |  Forum |  New Users |  Activities |  Interview FAQ |  Poll |  Hotlinks


Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.

Copyright © 2008-2011