Collation

Hey guys,
How do I
1) Set the COLLATION_SEQ to charset=iso_1 sort_order=nocase_iso
charset_num=1 sort_order_num=52 on the master database and rebuild it
2. Dictionary Order, Case Insensitive.
use Rebuildm.exe and specify collation , SQL Server will build master
database with new collation.
Regards
Amish Shah
|||Thanks Amish,
But I dont see a specific setting for
COLLATION_SEQ to charset=iso_1 sort_order=nocase_iso
charset_num=1 sort_order_num=52
Can u please help? Im new to SQL
Thanks
"amish" <shahamishm@.gmail.com> wrote in message
news:1144254842.055747.245210@.j33g2000cwa.googlegr oups.com...
> use Rebuildm.exe and specify collation , SQL Server will build master
> database with new collation.
> Regards
> Amish Shah
>
|||AFAIK default collation
dictionary order, case insensitive,for use with 1252 character set
is equivalent to this.
After installation to verify look at exec sp_server_info 18.
Regards
Amish Shah.
|||Seelan
Use the Rebuild master utility. It is Rebuildm.exe and it is located in the
Program Files\Microsoft SQL Server\80\Tools\Binn directory. See BOL ofr more
details.
regards
john
"Seelan Raja" wrote:

> Hey guys,
> How do I
> 1) Set the COLLATION_SEQ to charset=iso_1 sort_order=nocase_iso
> charset_num=1 sort_order_num=52 on the master database and rebuild it
> 2. Dictionary Order, Case Insensitive.
>
>
|||Thanks Guys,
One more thing,
IS there a website or a reference page where i can see the settings for
collation. For example, Amish said charset=iso_1 sort_order=nocase_iso
charset_num=1 sort_order_num=52 is DEFAULT collation.
Where can I see this table?
Thanks
"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%23VJymIMWGHA.5012@.TK2MSFTNGP05.phx.gbl...
> Hey guys,
> How do I
> 1) Set the COLLATION_SEQ to charset=iso_1 sort_order=nocase_iso
> charset_num=1 sort_order_num=52 on the master database and rebuild it
> 2. Dictionary Order, Case Insensitive.
>
sqlsql