<div>
Please try:<br />
<br />
Select <br />
SERVERPROPERTY ('Collation') Collation, <br />
SERVERPROPERTY ('SqlCharSetName') SqlCharSetName, <br />
SERVERPROPERTY ('SqlSortOrderName') SqlSortOrderName
</div>


Please try:

Select
SERVERPROPERTY ('Collation') Collation,
SERVERPROPERTY ('SqlCharSetName') SqlCharSetName,
SERVERPROPERTY ('SqlSortOrderName') SqlSortOrderName

<div>
wdosanjos; <br />
<br />
&nbsp; &nbsp; It give me the Collation type but no character set or sort order...........<br />
<br />
Latin1_General_CI_AS &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;iso_1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bin_ascii_8
</div>


wdosanjos;

    It give me the Collation type but no character set or sort order...........

Latin1_General_CI_AS      iso_1      bin_ascii_8

<div>
Latin1_General_CI_AS &nbsp;is the default collation for Windows U.S. English locale and is that what you see under SQL Server Properties??<br />
Regardless of the difference it looks like you have Accent-Sensitive/Case-Inse<wbr />nsitive and not the desired &quot;Accent-insensitive, case-insensitive&quot;<br />
<br />
<br />
Good luck!<br />

</div>


Latin1_General_CI_AS  is the default collation for Windows U.S. English locale and is that what you see under SQL Server Properties??
Regardless of the difference it looks like you have Accent-Sensitive/Case-Insensitive and not the desired "Accent-insensitive, case-insensitive"


Good luck!


<div>
Perfect thank you so much for your reply..........
</div>


Perfect thank you so much for your reply..........

<div>
<div class="content wysiwyg-content">
Hello Experts how would you go about finding out if these two &nbsp;have been set up. <br />
<br />
<br />
• &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Character Set: 1252 Multilanguage<br />
• &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sort Order: Accent-insensitive, case-insensitive<br />
<br />
I am installing a new application and these need to be set up before I can move on. &nbsp; Please help
</div>
</div>


Hello Experts how would you go about finding out if these two  have been set up. 


•	Character Set: 1252 Multilanguage
•	Sort Order: Accent-insensitive, case-insensitive

I am installing a new application and these need to be set up before I can move on.   Please help

Character Set and Sort Order

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.