Custom error messages prob

  • When I try to add a custom error message using sp_addmessage I get this error:

    "Server: Msg 15279, Level 16, State 1, Procedure sp_addmessage, Line 90. You must add the us_english version of this message before you can add the 'British' version."

    Is there a way round this? If not how do I add a us_english version on a British database?

    Thanks

    Peter

  • Below is the syntax for sp_addmessage. Specify us_english for the parameter @lang and add the message. After this you should be able to add the british version of the same message.

    sp_addmessage [ @msgnum = ] msg_id ,

        [ @severity = ] severity ,

        [ @msgtext = ] 'msg'

        [ , [ @lang = ] 'language' ]

        [ , [ @with_log = ] 'with_log' ]

        [ , [ @replace = ] 'replace' ]

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

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