Post reply

sql2008 version of "Accessing "sysmessages"

  • June 10, 2009 at 11:30 am

    #222437

    We have some old sql2000-centric code that runs this query:

    "select description from sys.messages where error = "

    What is the "proper" query to run under sql 2008? (Points will be given for an approach that does not need to directly access sysmessages.)

    TIA,

    barkingdog

  • June 10, 2009 at 11:35 am

    #1007589

    I think you are looking for something like this...

    select text from sys.messages where message_id = 101 and language_id = 1033

  • June 10, 2009 at 11:41 am

    #1007592

    There's no built-in system stored procedure or any kind of object that displays sys.messages.

    I think you will have to access it directly.

    Regards

    Gianluca

    -- Gianluca Sartori

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

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