Different Collations

Hi!
Have a question about collations...
I have a collation that cannot be chosen in the installation of sql server 2k. I found a solution for that and I dont know if its any good. I restore the model db with my collation (from another server) and then restart sql server. 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 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
JohanIt is not supported to have different collations between the system databases.
--
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 found a solution
for that and I dont know if its any good. I restore the model db with my collation (from another
server) and then restart sql server. 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 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 databases.
> --
> 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 found a solution
> for that and I dont know if its any good. I restore the model db with my collation (from another
> server) and then restart sql server. 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 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
>
>|||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...
> 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 databases.
> >
> > --
> > 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 found a
solution
> > for that and I dont know if its any good. I restore the model db with my collation (from another
> > server) and then restart sql server. 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 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, 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...
> > 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 databases.
> > >
> > > --
> > > 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 found a
> solution
> > > for that and I dont know if its any good. I restore the model db with my collation (from another
> > > server) and then restart sql server. 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 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
> > >
> > >
> > >
>
>|||You could always rebuild your system databases. Read about rebuildm.exe. Note 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 RESTORE 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...
> 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...
> > > 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 databases.
> > > >
> > > > --
> > > > 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 found a
> > solution
> > > > for that and I dont know if its any good. I restore the model db with my collation (from
another
> > > > server) and then restart sql server. 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 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
> > > >
> > > >
> > > >
> >
> >
> >|||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_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 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. Note 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 RESTORE 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...
> > 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...
> > > > 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 databases.
> > > > >
> > > > > --
> > > > > 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 found a
> > > solution
> > > > > for that and I dont know if its any good. I restore the model db with my collation (from
> another
> > > > > server) and then restart sql server. 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 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
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||I see. Yes, I know all about MS not exposing the Swedish SQL "ISO" collations in setup/rebuildm.exe.
Why I don't know. Unattended or upgrade of SQL7 are the only way I know to get 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 choose the same
colaltions as in the Sql2k installation. If you run an unattended installtion 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 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. Note 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 RESTORE 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...
> > > 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...
> > > > > 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 databases.
> > > > > >
> > > > > > --
> > > > > > 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 found
a
> > > > solution
> > > > > > for that and I dont know if its any good. I restore the model db with my collation (from
> > another
> > > > > > server) and then restart sql server. 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
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
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >