Server Collation

[dudenjersey]

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.

thanks in advance.

 

[MikeBatters]

During the install the option you want is to select:

Latin1_General
UnCheck: Case - sensitive (if ticked)
Check: Accent- sensitive

All others should be unchecked.

Mike

*************************************

Remember - There is always another way..........I just haven't found out what it is yet!