Error Handling + changes to sysmessages in SQL 2005

Error Handling + changes to sysmessages in SQL 2005

• InquiringMinds

  You can use the sp_addmessage system stored procedure to add custom messages.  It's fully documented in Books Online, so look up the notes and syntax there for more information.

   

  
  --
  Adam Machanic
  Pro SQL Server 2005, available now
  http://www..apress.com/book/bookDisplay.html bID=457
  --

   

   

  <jk_AnalysisServices@discussions.microsoft.com> wrote in message news:da106f4a-3148-4f9b-8b42-8f8126f8092d@discussions.microsoft.com...

  Hi....

  Im currently migrating a db from 2000 to 2005. Within the 2000 master database, I hold all my custom error messages in the sysmessages table.

  I'd like to insert the old error messages into the 2005 master database. Unfortunatley it seems that sysmessages has been replaced with a catologue view in 2005. Does anyone know where I can add my error messages now

  Many thanks

  Jeremy

  
  

• John Broomfield

  Thanks, thats unfortunately the conclusion I came to..

  Bit of a pain that you cant do this in the tables

  Thanks for your help

  Jeremy

  
  
• Error Handling + changes to sysmessages in SQL 2005