Hi All,

I didn't know one could change the collation without having to reload. I
am currently presented with the problem of having to do this change. Can
someone please let me know or point me to a website that explains how
this is done.

thanx
meshal

-----Original Message-----
From: Mandeep Bhutani [mailto:[Email Address Removed] 23 January 2004 07:00
To: LazyDBA.com Discussion
Subject: Re: Changing collation on SQL 2000


HI Anthony,

There is no other way than rebuilding the master DB
and while doing that u dont need to do anything with
msdb or model.

But keep the backup of all the user dbs as well, u
would require it at the later stage.

Regards
Mandeep


--- anthony.[Email Address Removed] wrote:
> Is there a faster way to change the sql collation on
> SQL 2000, than
> rebuilding the master db?
>
> If i rebuild the master db, do I need to do the same
> for msdb and model?
>
> I ask this because I have a clustered server which I
> need to change the
> character set and sort order on, and I dont want to
> re-install the whole
> thing.
>
> Thanks
> __________________________________________
> Anthony Hand
> DBA | Systems Integration
> Aon Risk Services Australia Ltd
> Ph: +61 2 9253 7516
> Fax: +61 2 92537952
>
>
>
>
> "The information contained in this email
> and any attached files
> is strictly private and confidential.
> This email should be
> read by the intended addressee only. If
> the recipient of this
> message is not the intended addressee,
> please call Aon Risk
> Services Australia, Aon Consulting, Aon
> Re Australia Ltd and
> other associated Aon Companies on +61 2
> 92537000 and promptly
> delete this email and any attachments.
>
> The intended recipient of this email may
> only use, reproduce,
> disclose or distribute the information
> contained in this email
> and any attached files with Aon's
> permission. If you are not
> the intended addressee, you are strictly
> prohibited from using,
> reproducing, disclosing or distributing
> the information
> contained in this email and any attached
> files.
>
> Aon advises that this email and any
> attached files should be
> scanned to detect viruses. Aon accepts
> no liability for loss
> or damage (whether caused by negligence
> or not) resulting from
> the use of any attached files."
>
>
>
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page