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 advancehI
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 thro
ugh 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 syst
em databases.
Also, changing collation through ALTER DATABASE does not change collation fo
r 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 choos
e
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 th
rough ALTER DATABASE
> (although I couldn't find it in BOL from a quick search). I know that ther
e exists a KB article
> describing that it is not supported to have different collation for the sy
stem 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 cho
ose
> 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 i
s definitely an SQL
> collation (the compatibility ones, at the lower part of the dialog). Latin
1 might be called ANSI or
> ISO. And then you should look for a collation with the number you want (12
53 in your case). Also, CS
> means Case Sensitive and AS means Accent Sensitive.
> Note that not all collations are available through SETUP / REBUILD. Some o
f the Swedish are among
> that list. In such cases, you can run an unattended install and specify th
e 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...
>
>