Default language set to bulgarian

Question

Post reply

Default language set to bulgarian

forsqlserver

SSCoach

Points: 18902
More actions
December 7, 2008 at 10:53 pm

#127320

Dear All
I m changing the login property of a user "abc" as default language set to bulgarian.
Where this change I'll able to see?bcoz when I m login with the user "abc" then everywhere english coming.
Thanx
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

run this t-sql

select name, language from syslogins

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 2

It should change the date format and error messages' language.

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

forsqlserver SSCoach Points: 18902 More actions · Answer 3

Dear

Thanx for the query

I have 2 questions

only 2 users are displaying by this query one is sa and other is "abc" while I have logined as sa.

and this Bulgariyan language impact on which part of db?

Thanx

Thanks

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 4

As I wrote you before, default language setting will only change the default date format that you'll see and the error message's language. If you want you can try and login to the server once as abc and once as SA and run the statement select getdate() to see the difference in the date format (assuming that each of this logins has a different default language that is using a different date format).

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

forsqlserver SSCoach Points: 18902 More actions · Answer 5

forsqlserver

SSCoach

Points: 18902

December 9, 2008 at 9:21 pm

#910050

Thanx a lot Adi..

Thanks