SQL server collation setting for TFS 2010


To work with Visual Studio Team System Team Foundation Server, the collation settings for SQL Server (2005 / 2008) must be:


1. case insensitive (clear the Case – sensitive check box), 


2. accent sensitive,


3. and not binary.


To avoid problems with double-width or hiragana/katakana-equivalent characters, you should select the check boxes to enable Kana and width sensitivity when you install SQL Server.

Comments (0)