Wednesday, March 28, 2012

How to change sort order of the server?

Hi i need to change teh sort order from :
Collation=Latin1_General_BIN, SQLSortOrder=0 to
Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52
Can you please tell me what is the best way"RS" <RS@.discussions.microsoft.com> wrote in message
news:C1A33FAA-0BAC-4A86-9438-ACA90AD00DF7@.microsoft.com...
> Hi i need to change teh sort order from :
> Collation=Latin1_General_BIN, SQLSortOrder=0 to
> Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52
> Can you please tell me what is the best way
Backup all of your user databases, or use sp_detach_db.
Run the rebuildm procedure to rebuild your master database. Choose a
different sort order.
Reattach your databases.
Rick Sawtell
MCT, MCSD, MCDBA|||HI i have the master DB with this Collation=SQL_Latin1_General_CP1_CI_AS,
SQLSortOrder=52 and i have deattache the DB that has the Latin1_General_BIN,
SQLSortOrder=0 and reattach again and nothing happen
do u have any other plans?
"Rick Sawtell" wrote:

> "RS" <RS@.discussions.microsoft.com> wrote in message
> news:C1A33FAA-0BAC-4A86-9438-ACA90AD00DF7@.microsoft.com...
> Backup all of your user databases, or use sp_detach_db.
> Run the rebuildm procedure to rebuild your master database. Choose a
> different sort order.
> Reattach your databases.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Hi
Use ALTER DATABASE command and ALTER TABLE ALTER COLUMN command for each
tables and columns.
Andras Jakus MCDBA
"RS" wrote:
[vbcol=seagreen]
> HI i have the master DB with this Collation=SQL_Latin1_General_CP1_CI_AS,
> SQLSortOrder=52 and i have deattache the DB that has the Latin1_General_BI
N,
> SQLSortOrder=0 and reattach again and nothing happen
> do u have any other plans?
> "Rick Sawtell" wrote:
>

No comments:

Post a Comment