Different Collations

Hi!
Have a question about collations...
I have a collation that cannot be chosen in the installation of sql server 2
k. I found a solution for that and I dont know if its any good. I restore th
e model db with my collation (from another server) and then restart sql serv
er. Then the temp db haves
the same collation as the model and everything works fine.
But the master dont have this collation, it has the original from the instal
lation...does this effect anything?
I cannot run an unattended setup (there you can specify your collation) beca
use I run this in a cluster.
Regards
JohanIt is not supported to have different collations between the system database
s.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Theos" <Theos@.discussions.microsoft.com> wrote in message
news:8E300FB6-CBB2-431C-96E8-B8AA77AC4893@.microsoft.com...
> Hi!
> Have a question about collations...
> I have a collation that cannot be chosen in the installation of sql server 2k. I f
ound a solution
for that and I dont know if its any good. I restore the model db with my col
lation (from another
server) and then restart sql server. Then the temp db haves the same collati
on as the model and
everything works fine.
> But the master dont have this collation, it has the original from the installation
..does this
effect anything?
> I cannot run an unattended setup (there you can specify your collation) because I
run this in a
cluster.
> Regards
> Johan|||Ok. Do you know where I can read about this? If it does affect anything and
what, or does MS just say that is it just not supported?
/Johan
"Tibor Karaszi" wrote:

> It is not supported to have different collations between the system databa
ses.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Theos" <Theos@.discussions.microsoft.com> wrote in message
> news:8E300FB6-CBB2-431C-96E8-B8AA77AC4893@.microsoft.com...
> for that and I dont know if its any good. I restore the model db with my c
ollation (from another
> server) and then restart sql server. Then the temp db haves the same colla
tion as the model and
> everything works fine.
> effect anything?
> cluster.
>
>|||I found it in a KB, I believe, about 1 to 2 years ago. I'd start with a KB s
earch for some obvious
keywords if you want to try to hunt this down...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JohanSql" <JohanSql@.discussions.microsoft.com> wrote in message
news:770F2019-9177-488E-918D-7A8AA44B98D5@.microsoft.com...
> Ok. Do you know where I can read about this? If it does affect anything and what,
or does MS just
say that is it just not supported?[vbcol=seagreen]
> /Johan
> "Tibor Karaszi" wrote:
>
solution[vbcol=seagreen]
a[vbcol=seagreen]|||Ok, thank you.
Do you know how any other way I can get the collation i want? Its no trouble
reinstalling it.
--
Regards
Johan
"Tibor Karaszi" wrote:

> I found it in a KB, I believe, about 1 to 2 years ago. I'd start with a KB
search for some obvious
> keywords if you want to try to hunt this down...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "JohanSql" <JohanSql@.discussions.microsoft.com> wrote in message
> news:770F2019-9177-488E-918D-7A8AA44B98D5@.microsoft.com...
> say that is it just not supported?
> solution
> a
>
>|||You could always rebuild your system databases. Read about rebuildm.exe. Not
e that this will scratch
all info in them, so be prepared to re-create your logins, linked servers, j
obs, alerts and all that
jazz. After your rebuild, you can sp_attach_db your user databases or RESTOR
E then (note that before
this, you should of course detach or BACKUP the databases).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JohanSql" <JohanSql@.discussions.microsoft.com> wrote in message
news:C3AF2B5A-5D2C-4220-A445-3AAADBBD459F@.microsoft.com...[vbcol=seagreen]
> Ok, thank you.
> Do you know how any other way I can get the collation i want? Its no troub
le reinstalling it.
> --
> Regards
> Johan
>
> "Tibor Karaszi" wrote:
>
obvious[vbcol=seagreen]
just[vbcol=seagreen]
another[vbcol=seagreen]
and[vbcol=seagreen]
this[vbcol=seagreen]
in[vbcol=seagreen]|||I tried to run rebuild.exe but I still cant get the collation I want. I can
only choose the same colaltions as in the Sql2k installation. If you run an
unattended installtion then you can specify your collation, like "SQL_Swedis
hStd_Pref_CP1_CI_AS" wich i
s the one I want. The only solution I know is to install Sql7 first and then
run Sql2k over it, then I get my original collation, but I dont want to do
that.
Any suggestions'
--
Regards
Johan
"Tibor Karaszi" wrote:

> You could always rebuild your system databases. Read about rebuildm.exe. N
ote that this will scratch
> all info in them, so be prepared to re-create your logins, linked servers,
jobs, alerts and all that
> jazz. After your rebuild, you can sp_attach_db your user databases or REST
ORE then (note that before
> this, you should of course detach or BACKUP the databases).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "JohanSql" <JohanSql@.discussions.microsoft.com> wrote in message
> news:C3AF2B5A-5D2C-4220-A445-3AAADBBD459F@.microsoft.com...
> obvious
> just
> another
> and
> this
> in
>
>|||I see. Yes, I know all about MS not exposing the Swedish SQL "ISO" collation
s in setup/rebuildm.exe.
Why I don't know. Unattended or upgrade of SQL7 are the only way I know to g
et sys databases with
such a collation...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"JohanSql" <JohanSql@.discussions.microsoft.com> wrote in message
news:9A3A54E2-0DD4-4F6E-8190-A647DC81118B@.microsoft.com...
> I tried to run rebuild.exe but I still cant get the collation I want. I can only c
hoose the same
colaltions as in the Sql2k installation. If you run an unattended installtio
n then you can specify
your collation, like "SQL_SwedishStd_Pref_CP1_CI_AS" wich is the one I want.
The only solution I
know is to install Sql7 first and then run Sql2k over it, then I get my orig
inal collation, but I
dont want to do that.[vbcol=seagreen]
> Any suggestions'
> --
> Regards
> Johan
>
> "Tibor Karaszi" wrote:
>
scratch[vbcol=seagreen]
that[vbcol=seagreen]
before[vbcol=seagreen]
MS[vbcol=seagreen]
a[vbcol=seagreen]
model[vbcol=seagreen]
installation...does[vbcol=seagreen]
this[vbcol=seagreen]