Re: Different Collations
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/29/04
- Next message: Hari: "Re: Cannot start SQL 2000"
- Previous message: Narayana Vyas Kondreddi: "Re: column description?"
- In reply to: JohanSql: "Re: Different Collations"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 29 Jun 2004 15:16:13 +0200
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 > > > > > > > > > > > > > > > > > >
- Next message: Hari: "Re: Cannot start SQL 2000"
- Previous message: Narayana Vyas Kondreddi: "Re: column description?"
- In reply to: JohanSql: "Re: Different Collations"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
