[windows2000] Re: OT: Changing the default language on MSSQL 2000

  • From: "Mauricio Fernandez" <mfernandez@xxxxxxxxxxxxxxx>
  • To: <windows2000@xxxxxxxxxxxxx>
  • Date: Fri, 29 Oct 2004 09:24:47 -0400

We need to clarify something:

You just want to change de LANGUAGE? or you need to change the COLLATION of
your database?

If you are having problems with referential integrity creation, probably
your problem is with the COLLATION language.

Both things can be changed:

Language -> just like Nick explain you
Collate -> Use the COLLATE instruction.

Good luck,



Mauricio Fernández S.
IT Manager
FDTA - Valles
Tel. 591 4 4525160
Fax. 591 4 4115056
mfernandez@xxxxxxxxxxxxxxx
www.fdta-valles.org
 

-----Original Message-----
From: windows2000-bounce@xxxxxxxxxxxxx
[mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Angus Macdonald
Sent: Friday, October 29, 2004 8:39 AM
To: windows2000@xxxxxxxxxxxxx
Subject: [windows2000] OT: Changing the default language on MSSQL 2000

I've just found out that the default language on one of my MSSQL 2000 boxes
is wrong. It was left as US (as was the server it lives on) when it was
installed and an application vendor is claiming this as the reason for his
software giving trouble. Can anyone point me towards a resource with
step-by-step instructions for changing the system default language to UK
English? I've changed the Win2K server settings but MSSQL still thinks it's
american.

Regards

Angus Macdonald
Corporate Systems Manager
North West Wales NHS Trust
YG ext 4167

Gallai'r e-bost yma gynnwys gwybodaeth gyfrinachol a/neu ddeunydd
hawlfraint.  Os ydych chi'n meddwl eich bod wedi derbyn yr e-bost yma drwy
gamgymeriad rydym yn ymddiheuro am hyn; peidiwch os gwelwch yn dda â
datgelu, anfon ymlaen, printio, copïo na dosbarthu gwybodaeth yn yr e-bost
yma na gweithredu mewn unrhyw fodd drwy ddibynnu ar ei gynnwys: gwaherddir
gwneud hynny'n gyfan gwbl a gallai fod yn anghyfreithlon. Rhowch wybod i'r
anfonwr fod y neges yma wedi mynd ar goll cyn ei dileu.
 
Mae unrhyw safbwynt neu farn a gyflwynir yn eiddo i'r awdur ac nid ydynt o
anghenraid yn cynrychioli safbwynt neu farn Ymddiriedolaeth GIG Gogledd
Orllewin Cymru.

Gallai cynnwys yr e-bost yma gael ei ddatgelu i'r cyhoedd o dan Gôd Bod yn
Agored y GIG neu Ddeddf Rhyddid Gwybodaeth 2000.  Nid oes modd gwarantu
cyfrinachedd y neges ac unrhyw ateb. 

Bydd y neges yma ac unrhyw ffeiliau cysylltiedig wedi cael eu gwirio gan
feddalwedd canfod firws cyn eu trosglwyddo.  Ond rhaid i'r sawl sy'n derbyn
wirio rhag firws ei hun cyn agor unrhyw ymgysylltiad.  Nid yw'r
Ymddiriedolaeth yn derbyn unrhyw gyfrifoldeb am unrhyw golled neu niwed a
allai gael ei achosi gan firws meddalwedd.


This e-mail may contain confidential information and/or copyright material.
If you believe that you have received this e-mail in error please accept our
apologies; please do not disclose, forward, print, copy or distribute
information in this e-mail or take any action in reliance on its contents:
to do so is strictly prohibited and may be unlawful.  Please inform the
sender that this message has gone astray before deleting it.

Any views or opinions presented are to be understood as those of the author
and do not necessarily represent those of the North West Wales NHS Trust.

The contents of this e-mail may be subject to public disclosure under the
NHS Code of Openness or the Freedom of Information Act 2000.  The
confidentiality of the message and any reply cannot be guaranteed.

This message and any attached files will have been checked with virus
detection software before transmission.  However, recipients must carry out
their own virus checks before opening any attachment.  The Trust accepts no
liability for any loss or damage, which may be caused by software viruses.

********************************************************
This Weeks Sponsor StressedPuppy.com Games
Feeling stressed out? Check out our games to
relieve your stress.
http://www.StressedPuppy.com
********************************************************
To Unsubscribe, set digest or vacation
mode or view archives use the below link.

http://thethin.net/win2000list.cfm

********************************************************
This Weeks Sponsor StressedPuppy.com Games
Feeling stressed out? Check out our games to
relieve your stress.
http://www.StressedPuppy.com
********************************************************
To Unsubscribe, set digest or vacation
mode or view archives use the below link.

http://thethin.net/win2000list.cfm

Other related posts: