<div>
ALTER DATABASE Pubs COLLATE sql_latin1_general_pref_cp<wbr />1_ci_as<br />
GO<br />

</div>


ALTER DATABASE Pubs COLLATE sql_latin1_general_pref_cp1_ci_as
GO


<div>
I have to change the master db.....is it the same?
</div>


I have to change the master db.....is it the same?

<div>
For your database you can do as:<br />
<br />
ALTER DATABASE yourdatabasename COLLATE sql_latin1_general_pref_cp<wbr />1_ci_as<br />
GO
</div>


For your database you can do as:

ALTER DATABASE yourdatabasename COLLATE sql_latin1_general_pref_cp1_ci_as
GO

<div>
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_819v.asp" rel="ugc nofollow">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_819v.asp</a><br />
<br />
You can also use the COLLATE clause on an ALTER DATABASE to change the default collation of the database:<br />
<br />
ALTER DATABASE MyDatabase COLLATE French_CI_AS<br />
<br />

</div>


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_819v.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_819v.asp]

You can also use the COLLATE clause on an ALTER DATABASE to change the default collation of the database:

ALTER DATABASE MyDatabase COLLATE French_CI_AS



<div>
<div class="content wysiwyg-content">
My current sql server db is sql_latin1_general_cp1_ci_<wbr />as......I need to change it to sql_latin1_general_pref_cp<wbr />1_ci_as.<br />
<br />
<br />
Any ideas on which collation to select when installing Sql Server 2000? &nbsp;There are tons to choose from and I can't seem to get the right one. &nbsp;<br />
<br />
Thanks<br />
<br />
Tim
</div>
</div>


My current sql server db is sql_latin1_general_cp1_ci_as......I need to change it to sql_latin1_general_pref_cp1_ci_as.


Any ideas on which collation to select when installing Sql Server 2000?  There are tons to choose from and I can't seem to get the right one.  

Thanks

Tim

Sql Server Collation

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.