SQL Server 2000I need to change the collation for a database from case senstitive to case insensitive. ALTER DATABASE COLLATE SQL_Latin1_General_CI_AS When I try to so, I get a whole slew of ...

I don't have any real data on the server yet, but I need to change the collation settings so that this server will match the settings of an SQL 2000 remote server.<BR><BR>So I figured forget ...

SELECT statement. SQL Server 2000 introduces SQL collations, a large collection of named collation types that specify different combinations of character sets and sort orders.