sql 2005 version - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

sql 2005 version

Author

Topic

wided
Posting Yak Master

218 Posts

Posted - 2011-05-03 : 05:19:50

installed sql 2005 English version
I have a problem with dates
is it possible to change the language by default without reinstalling because the database is already operational

in option ownership, I have changed the advanced settings the default language, but it is not possible to change language in the "General"
Écouter
Lire phonétiquement
Nouveau ! Cliquez sur le

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-05-03 : 05:21:32

take a look at this:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62891

In Love With Me!

wided
Posting Yak Master

218 Posts

Posted - 2011-05-03 : 05:23:34

I installed sql 2005 English version
I have a problem with dates
is it possible to change the language by default without reinstalling because the database is already operational

in option "proprety", I have changed the advanced settings the default language (french), but it is not possible to change language in the "General"

thanks

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-05-03 : 05:47:15

Ok For dates you can change your system date and language from (regional and language Option) from the control panel.
For SQL
--1 st run this
sp_configure 'Advanced option',1
reconfigure with override
--2nd this
EXEC sp_configure 'default language', 2
reconfigure with override
--3rd this
sp_configure 'Advanced option',0
reconfigure with override
after running all close your SSMS and re-open
In Love With Me!

wided
Posting Yak Master

218 Posts

Posted - 2011-05-03 : 05:55:28

but if i do this
thanks
i do this

EXEC sp_configure 'default language', 2--french
RECONFIGURE

it is ok

SELECT @@language, @@langid

it is always 23
I stopped services and restarted

what can i do?

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-05-03 : 05:59:38

Actually If you use
Exec sp_configure 'default language',2
reconfigure with override
Then you don't need to restart your Services
Ok you need to re open your SSMS

In Love With Me!

wided
Posting Yak Master

218 Posts

Posted - 2011-05-03 : 06:11:16

it is ok for the page "advanced"

but i need tou change the first page "Language"
which is grayed
with other options (name of server, os, processor, language...)
can i change it with sp_configure or other
thanks

wided
Posting Yak Master

218 Posts

Posted - 2011-05-03 : 06:37:32

thanks,

i wait

wided
Posting Yak Master

218 Posts

Posted - 2011-05-04 : 07:07:10

please
can you respons me

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources