Post reply

Missing SysMessages

  • 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

  • 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]

  • 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

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

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