Rebuild Master

Hello experts,
I'm making my "questions" again cause nobody answered 4 days now.
I want to rebuild my master DB because I want to change my Collation. What
are my problems:
1) I don't know which SQL collation to choose from the list to get collation
SQL_Latin1_General_CP1253_CS_AS
2) When I specify the Data folder then an error occurs and "sais" that
cannot copy the master files (something like that). I'm not in position to
tell you the exact message.
Thanks in advance
hI
You don't need to rebuild master database in order to change a collation.
Look at ALTER DATABASE command in the BOL.
"x-rays" <xrays@.discussions.microsoft.com> wrote in message
news:DDC20EBC-F751-4B4E-92E5-0A2ECDEDBDAE@.microsoft.com...
> Hello experts,
> I'm making my "questions" again cause nobody answered 4 days now.
> I want to rebuild my master DB because I want to change my Collation. What
> are my problems:
> 1) I don't know which SQL collation to choose from the list to get
collation
> SQL_Latin1_General_CP1253_CS_AS
> 2) When I specify the Data folder then an error occurs and "sais" that
> cannot copy the master files (something like that). I'm not in position to
> tell you the exact message.
> Thanks in advance
>
|||aha, one more thing, master's collation is Server's collation too right?
"Uri Dimant" wrote:

> hI
> You don't need to rebuild master database in order to change a collation.
> Look at ALTER DATABASE command in the BOL.
>
> "x-rays" <xrays@.discussions.microsoft.com> wrote in message
> news:DDC20EBC-F751-4B4E-92E5-0A2ECDEDBDAE@.microsoft.com...
> collation
>
>
|||I'm pretty certain you cannot change collation for the system databases through ALTER DATABASE
(although I couldn't find it in BOL from a quick search). I know that there exists a KB article
describing that it is not supported to have different collation for the system databases.
Also, changing collation through ALTER DATABASE does not change collation for existing objects.
IMO, you are in for rebuildm.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"x-rays" <xrays@.discussions.microsoft.com> wrote in message
news:A9E3061A-F52B-4ECB-89EC-B6B9036C4B25@.microsoft.com...[vbcol=seagreen]
> aha, one more thing, master's collation is Server's collation too right?
> "Uri Dimant" wrote:
|||Yes I agree, I don't think is a good idea to ALTER my system DBs to change
their collation, do you have an answer for the collation tha I wish to choose
from the list of rebuildm.exe UI? I'd like the
"SQL_Latin1_General_CP****_CS_AS" ones.
Thanks in advance
"Tibor Karaszi" wrote:

> I'm pretty certain you cannot change collation for the system databases through ALTER DATABASE
> (although I couldn't find it in BOL from a quick search). I know that there exists a KB article
> describing that it is not supported to have different collation for the system databases.
> Also, changing collation through ALTER DATABASE does not change collation for existing objects.
> IMO, you are in for rebuildm.exe.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "x-rays" <xrays@.discussions.microsoft.com> wrote in message
> news:A9E3061A-F52B-4ECB-89EC-B6B9036C4B25@.microsoft.com...
>
>
|||I don't have a machines form where I can run setup at the moment. But it is definitely an SQL
collation (the compatibility ones, at the lower part of the dialog). Latin1 might be called ANSI or
ISO. And then you should look for a collation with the number you want (1253 in your case). Also, CS
means Case Sensitive and AS means Accent Sensitive.
Note that not all collations are available through SETUP / REBUILD. Some of the Swedish are among
that list. In such cases, you can run an unattended install and specify the collation in the ISS
file. I'm not sure how to do this if you want to do a rebuild, though...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"x-rays" <xrays@.discussions.microsoft.com> wrote in message
news:443C0FB1-299A-4309-BD91-A66AFCA86872@.microsoft.com...[vbcol=seagreen]
> Yes I agree, I don't think is a good idea to ALTER my system DBs to change
> their collation, do you have an answer for the collation tha I wish to choose
> from the list of rebuildm.exe UI? I'd like the
> "SQL_Latin1_General_CP****_CS_AS" ones.
> Thanks in advance
> "Tibor Karaszi" wrote:
|||I see, thank you very much for your time.
"Tibor Karaszi" wrote:

> I don't have a machines form where I can run setup at the moment. But it is definitely an SQL
> collation (the compatibility ones, at the lower part of the dialog). Latin1 might be called ANSI or
> ISO. And then you should look for a collation with the number you want (1253 in your case). Also, CS
> means Case Sensitive and AS means Accent Sensitive.
> Note that not all collations are available through SETUP / REBUILD. Some of the Swedish are among
> that list. In such cases, you can run an unattended install and specify the collation in the ISS
> file. I'm not sure how to do this if you want to do a rebuild, though...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "x-rays" <xrays@.discussions.microsoft.com> wrote in message
> news:443C0FB1-299A-4309-BD91-A66AFCA86872@.microsoft.com...
>
>