Collation

Hey guys,
How do I
1) Set the COLLATION_SEQ to charset=iso_1  sort_order=nocase_is
o
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_is
o

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.googlegroups.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_is
o
> 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_is
o
charset_num=1 sort_order_num=52 is DEFAULT collation.

Where can I see this table??

Thanks

"Seelan Raja" < seelan_rd@NOSPAMyaho
o.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_is
o
> charset_num=1 sort_order_num=52 on the master database and rebuild it
>
> 2. Dictionary Order, Case Insensitive.
>
>