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
Johan
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
|||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. 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...
> 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.
> effect anything?
> cluster.
>
>
|||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...
> 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.
> effect anything?
> cluster.
>
>
|||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?[vbcol=seagreen]
> /Johan
> "Tibor Karaszi" wrote:
solution[vbcol=seagreen]
a[vbcol=seagreen]
|||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?[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
>
>
|||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. 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...[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:
obvious[vbcol=seagreen]
just[vbcol=seagreen]
another[vbcol=seagreen]
and[vbcol=seagreen]
this[vbcol=seagreen]
in[vbcol=seagreen]