Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Setting Server Collation - HELP

Author  Topic 

johnmcc
Starting Member

4 Posts

Posted - 2007-08-03 : 10:22:58
Hi,

We had to rebuild one of our 64bit servers which runs SQL2000 Enterprise (64bit). While installing SQL, we are not seeing the collation that we need, what we need is SQL_Latin_General_CP1_CI_AS, but that isn't listed as an option, this is driving us nutz, any help would be GREATLY appreciated. I checked all regional settings, we are set to US, Eastern Timezone, nothing different.

thanks in advance

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-03 : 11:32:33
This is default collation.
Go to Top of Page

johnmcc
Starting Member

4 Posts

Posted - 2007-08-03 : 14:49:43
Thanks for your reply, we understand this is the default what but we are not seeing it during the install, i was wondering if anyone could help me to force it during the install.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-03 : 23:46:35
It listed something like dictionary order, case insencitive as I remember.
Go to Top of Page
   

- Advertisement -