SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005 language


SQL Server 2005 language

Author
Message
river1
river1
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4530 Visits: 1366
Hi,

I want to change the language of my SQL Server from english to portuguese.
How can i do this?

What chabges apen after language is changed?


What it will affect.


Thank you
Skull Killer
Skull Killer
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1778 Visits: 422
You want to change the entire server default language, one logins or one sessions language.
When changing language, the sql server messages will change, the datefirst may be different, the datenames returns will change, ....

to change the default language of the server

EXEC sp_configure 'default language', 9
RECONFIGURE



To change the default language of a login:
ALTER LOGIN sa WITH DEFAULT_LANGUAGE = Portuguese;



To change the language in a session:
SET Language Portuguese



Remember that changing a server default labguage doesn't change the preexisting logins or sessions default language.

The table master..syslanguages has information about languages.
river1
river1
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4530 Visits: 1366
Hi,

I have made this:

EXEC sp_configure 'default language', 9
RECONFIGURE


Then i receved this:

Configuration option 'default language' changed from 0 to 9. Run the RECONFIGURE statement to install.


Don't understand what is this "Run the RECONFIGURE statement to install."


Can you please explain?

Thank you
GilaMonster
GilaMonster
SSC Guru
SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)

Group: General Forum Members
Points: 230034 Visits: 46344
river1 (2/26/2010)
Don't understand what is this "Run the RECONFIGURE statement to install."


It's referring to the RECONFIGURE statement, the one in the script you posted. Any change to sp_configure will produce that statement. It's saying that you need to run RECONFIGURE, which you did.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Skull Killer
Skull Killer
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1778 Visits: 422
The reconfigure statement is already in the statement. But the message from the first statement gives that.
That's because sql server has configured values and running values when it deals with server configurations. When one runs sp_configure it changes only the configured values. Then the reconfigure statement "copies" configured values to running values. This way you can change several configurations and put it to run only one time.

Read abou sp_configure and reconfigure on books online.
river1
river1
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4530 Visits: 1366
Hi,

Maybe it's better for my to put the direct question that i want to know.

The problem is this:

I'm printing some reports (standard reports) and the language is english.

If i change the default language to portuguese will the reports be printed using portuguese language? or will they still use English as the language of the report?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)

Group: General Forum Members
Points: 230034 Visits: 46344
What reports?

Changing the language will not translate data stored in the database, nor will it translate anything that's explicitly put on to a report, if we're talking about reporting services reports here.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


river1
river1
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4530 Visits: 1366
I'm talking about the standar reports that come with SQL Server 2005.

For instance, if i right click on a database a menu will appear.

In this menum you have an entry named "Reports"

If you click there (reports) you will see Standard reports.

I'm curretly working on the report "Disk Usage"


The entire language of the reports is english.

If i change the default language of the server to portuguese will the reports come with information in portuguese?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)SSC Guru (230K reputation)

Group: General Forum Members
Points: 230034 Visits: 46344
It doesn't appear to. I just tried it out, switching my server to french and running the reports. Still in English.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


river1
river1
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4530 Visits: 1366
Ok. In that case i can not print the standard reports that came with SQL Server 2005 in my mother language.

Thank you Gail
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search