Post reply

SQL Server Default Language Settings

  • June 19, 2006 at 4:44 am

    #62409

    I have just tripped up on a lovely SQL feature which no matter what I try doesn’t seem to do anything…..

     

    When I built the Servers I was extra careful in checking that the Servers were set to English British but for some reason SQL has other ideas

     

    I have run the “SET Language British” option on the Master databases of all my servers an that seems to have done the trick but when I check the properties of the server it still shows English (United States)… how can I change this

     

     

  • June 19, 2006 at 5:13 pm

    #644718

    i think you have to change default collation for this server to have Language = BritishEnglish. go to this path & need to run rebuildm.exe.

    Install Path = D:\Program Files\Microsoft SQL Server\80\Tools\Binn

     

    I hope this will help.

  • June 20, 2006 at 1:15 am

    #644736

    Hi...  I have had a look there but cant see English British.. I have scrolled down and it just is not there..

  • June 21, 2006 at 9:19 am

    #645057

    Shane

    Have a look under B for Bristish English, not E for English British.

    John

Viewing 4 posts - 1 through 3 (of 3 total)

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