Missing SysMessages

• Spamot Ide

  SSC-Addicted

  Points: 447

  More actions

  March 3, 2014 at 3:50 am

  #288849

  Hi,

  I've a 2008R2 SQL server, and I would like to change the language in a session (to localize messages). But there isn't all messages in sysmessages table, only 11 language. When I query the syslanguages table, I see 33 languages (including the necessary).

  Why? Need to install / script the localized system messages?

  Regards,

  Peter

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  March 3, 2014 at 7:42 am

  #1693557

  You can add user defined error messages to your system by using error message numbers greater than 50,000. To learn how to do this please read.

  http://www.techrepublic.com/blog/the-enterprise-cloud/define-custom-error-messages-in-sql-server-2005/390/

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• Spamot Ide

  SSC-Addicted

  Points: 447

  More actions

  March 3, 2014 at 8:00 am

  #1693563

  Hi Ron,

  I know it.

  But I need the built-in error messages localization. For example, I need the "Could not find stored procedure 'somthing'." standard error message (MsgID: 2812) on other language.

  So, when a user makes a mistake, then receive the localized message. When the (SQL) user's language is Ubuntu, or Dutch, then the SQL server localize the messages in this case.

  Regards,

  Peter