|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
install sqlexpress 2005 with specific collateI want to install sqlexpress 2005 with collate SQL_Latin1_General_CP1_CI_AS
because my database have it an when I use tempdb jmeykos (jmey***@discussions.microsoft.com) writes:
> I want to install sqlexpress 2005 with collate So install it then. You may have to check Show Advanced Options when you> SQL_Latin1_General_CP1_CI_AS because my database have it an when I use > tempdb install Express to be able to set the collation. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx but in the installation don't appears SQL_Latin1_General_CP1_CI_AS just
Latin1_General Show quote "Erland Sommarskog" wrote: > jmeykos (jmey***@discussions.microsoft.com) writes: > > I want to install sqlexpress 2005 with collate > > SQL_Latin1_General_CP1_CI_AS because my database have it an when I use > > tempdb > > So install it then. You may have to check Show Advanced Options when you > install Express to be able to set the collation. > > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Books Online for SQL Server 2005 at > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx > Books Online for SQL Server 2000 at > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > jmeykos (jmey***@discussions.microsoft.com) writes:
> but in the installation don't appears SQL_Latin1_General_CP1_CI_AS just The collation screen has two parts. In the upper half you are presented> Latin1_General Windows Collation and their options. In the lower half there is a list box with the SQL collations. There is also a some mechanism to choose whether you want a Windows collation or an SQL collation, although I don't remember exactly it looks like. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics