disable all triggers: installation

Showing posts with label installation. Show all posts

Monday, March 19, 2012

differentiating between MSDE and other SQL Server editions

I want to be able to detect whether a SQL server installation is a pure SQL
server installation or an MSDE installation. I want to be able to differenti
ate
between these 2. I have seen the following observations after running select
serverproperty('edition') command and running select @.@.version command.
No
As seen in add/ remove programs
Result of "select @.@.version"
Result of "select serverproperty('edition')"
1.
Microsoft SQL Server Desktop Engine (version 8.00.760)
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 C
opyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT
5.1 (Build 2600: Service Pack 1)
Personal edition
2.
Microsoft SQL Server 2000 (version 8.00.761)
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 C
opyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows N
T 5.1 (Build 2600: Service Pack 1)
Developer Edition
3.
Microsoft SQL Server Desktop Engine (version 8.00.760)
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 C
opyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5
.1 (Build 2600: Service Pack 1)
Desktop Engine
4.
Microsoft SQL Server Desktop Engine
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 C
opyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5
.0 (Build 2195: Service Pack 3)
Desktop Engine
5.
Microsoft SQL Server 2000 (version 8.00.894)
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 C
opyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT
5.0 (Build 2195: Service Pack 3)
Standard Edition
6.
Microsoft SQL Server 2000 (version 8.00.761)
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 C
opyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: )
Enterprise Edition
As mentioned in this article http://www.microsoft.com/sql/evalua...
ult.asp on Microsoft site, personal edition and desktop engine are 2 differe
nt editions in MS SQL 2000. Then the observation made in result 1 of this ta
ble, is it a defect? It surely shows me as Microsoft SQL Server Desktop Engi
ne in Add / Remove programs although I have the personal edition installed o
n my machine.
Is it an intended behavior to treat "personal edition" as "desktop engine" a
nd show it that way in Add/ remove programs?
Thanks.Hi
I get the correct results!
SET NOCOUNT ON
select '@.@.version' AS Command
SELECT @.@.version AS Version
select 'serverproperty(''edition'')' AS Command
SELECT serverproperty('edition') AS Edition
/*
Command
--
@.@.version
Version
---
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
Command
--
serverproperty('edition')
Edition
---
Personal Edition
*/
John
"Onkar Walavalkar" wrote:

> I want to be able to detect whether a SQL server installation is a pure S
QL server installation or an MSDE installation. I want to be able to differe
ntiate
> between these 2. I have seen the following observations after running sele
ct serverproperty('edition') command and running select @.@.version command.
>
> No
> As seen in add/ remove programs
> Result of "select @.@.version"
> Result of "select serverproperty('edition')"
> 1.
> Microsoft SQL Server Desktop Engine (version 8.00.760)
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22
:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Win
dows NT 5.1 (Build 2600: Service Pack 1)
> Personal edition
> 2.
> Microsoft SQL Server 2000 (version 8.00.761)
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22
:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Wi
ndows NT 5.1 (Build 2600: Service Pack 1)
> Developer Edition
> 3.
> Microsoft SQL Server Desktop Engine (version 8.00.760)
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22
:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windo
ws NT 5.1 (Build 2600: Service Pack 1)
> Desktop Engine
> 4.
> Microsoft SQL Server Desktop Engine
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22
:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windo
ws NT 5.0 (Build 2195: Service Pack 3)
> Desktop Engine
> 5.
> Microsoft SQL Server 2000 (version 8.00.894)
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57
:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Win
dows NT 5.0 (Build 2195: Service Pack 3)
> Standard Edition
> 6.
> Microsoft SQL Server 2000 (version 8.00.761)
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22
:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on W
indows NT 5.2 (Build 3790: )
> Enterprise Edition
>
>
> As mentioned in this article http://www.microsoft.com/sql/evalua...ult.as
p on Microsoft site, personal edition and desktop engine are 2 different editions in
MS SQL 2000. Then the observation made in result 1 of this table, is it a defect[/c
olor]
? It surely shows me as Microsoft SQL Server Desktop Engine in Add / Remove programs althou
gh I have the personal edition installed on my machine.
>
> Is it an intended behavior to treat "personal edition" as "desktop engine"
and show it that way in Add/ remove programs?
>
> Thanks.
>
>
>|||I am also getting 'personal edition' after running "select @.@.version" and
"select serverproperty('edition')" for personal edition installation. The
problem I face is in "Add/ Remove Pragrams". Here I see "Microsoft SQL
Server Desktop Engine" for both MSDE and personal edition. What I am asking
is if that is an expected behavior to treat personal edition as MSDE and
display MSDE (and not Microsft SQL Server 2000) for personal edition.
John, for your personal edition installation, can you please tell me what
you see in "Add/ Remove programs"?
thanks,
onkar
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:EFFC17F2-FF8B-49D8-9E47-BD77D2E50AF8@.microsoft.com...
> Hi
> I get the correct results!
> SET NOCOUNT ON
> select '@.@.version' AS Command
> SELECT @.@.version AS Version
> select 'serverproperty(''edition'')' AS Command
> SELECT serverproperty('edition') AS Edition
> /*
> Command
> --
> @.@.version
> Version
> ---
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>
> Command
> --
> serverproperty('edition')
> Edition
> ---
> Personal Edition
> */
> John
> "Onkar Walavalkar" wrote:
>
SQL server installation or an MSDE installation. I want to be able to
differentiate
select serverproperty('edition') command and running select @.@.version
command.
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition
on Windows NT 5.1 (Build 2600: Service Pack 1)
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition
on Windows NT 5.1 (Build 2600: Service Pack 1)
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on
Windows NT 5.1 (Build 2600: Service Pack 1)
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on
Windows NT 5.0 (Build 2195: Service Pack 3)
00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition
on Windows NT 5.0 (Build 2195: Service Pack 3)
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition
on Windows NT 5.2 (Build 3790: )
http://www.microsoft.com/sql/evalua...iew/default.asp on Microsoft
site, personal edition and desktop engine are 2 different editions in MS SQL
2000. Then the observation made in result 1 of this table, is it a defect?
It surely shows me as Microsoft SQL Server Desktop Engine in Add / Remove
programs although I have the personal edition installed on my machine.
engine" and show it that way in Add/ remove programs?|||Hi
I see "Microsft SQL Server 2000", but I have never had MSDE on this
machine. You may want to remove everything and try a fresh install.
John

Wednesday, March 7, 2012

Different SQL server 2005 Editions from the same Installation CD?!

I have the SQL Server 2005 Enterprise Edition CD and have succesfully installed this on my desktop.

When I install this on my Laptop the version is 2000(print @.@.version) is only Desktop version (2gb db limit!)....

Any ideas on why the full enterprise edition is not installing on the laptop?!!

Version on my Desktop:
MICROSOFT SQL SERVER 2005-9.00.1399.06 (INTEL X86)
OCT 14 2005 00.33.37
1988-2005 microsoft corp
enterprise edition on windows NT 5.2 (build 3790-service pack)

Version on my laptop:
MICROSOFT SQL SERVER 2000-8.00.2039(INTEL X86)
May 14 2005 23:18:38
Copyright (c) 1988-2005 Microsoft Corporation
desktop engine on windows NT 5.1 (build 2600: service pack 2)

The Laptop spec is:
Intel 1.66Ghz, 1 Gb Ram, 50 Gb HDD, Windows XP SP2

The Desktop spec is:
Intel 2.8 Ghz Dual Core, 2 Gb Ram, 320 Gb HDD, Windows XP SP2

Both SQL Server 2005 versions are installed from the same CD so why would there be a difference?

I understand that you cannot have Enterprise edition on XP but it has installed on the desktop, not the laptop?

Thanks in advance!

EE does not support Windows XP as a OS. Could it be that you have developer edition installed ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||When I use the command print @.@.version on my desktop, it states that it is Enterprise Edition.....|||

Based on the information you provided, your laptop has Windows XP SP2. SQL Server enterprise edition requires a server OS and will not install on Windows XP, which is a client OS. Thus, you can not install it on your laptop.

Look closely at your @.@.version information from your desktop. It indicates that your desktop computer has Windows 5.2, which is Windows 2003 Server, NOT Windows XP. Windows 2003 Server will support an installation of SQL Server 2005 enterprise edition. Thus, I would expect you to be able to install SQL Server 2005 enterprise edition on your desktop, but not on your laptop.

I do not understand the statement... "Both SQL Server 2005 versions are installed from the same CD so why would there be a difference?"

Looking at the @.@.version information on your desktop and laptop indicate that SQL 2005 is install on your desktop, but SQL 2000 is install on your laptop. I do not see any indication that SQL 2005 is install on the laptop.

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

Sunday, February 19, 2012

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
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >

Monday, March 19, 2012

differentiating between MSDE and other SQL Server editions

Wednesday, March 7, 2012

Different SQL server 2005 Editions from the same Installation CD?!

Sunday, February 19, 2012

Different Collations

Different Collations

Different Collations

disable all triggers

Blog Archive

About Me