I working on a project where I want to utilize RAISERROR for informational messages. I have read all of the documentation available on the syntax and I am confortable with it. What I am interested in is information about how others have implemented sysmessages. I am trying to find a numbering scheme that others have used that works. It seems to me that a generic set of messages could be developed and used for all applications, with a range for application specific errors.

Anybody out there use RAISERROR before and care to shed some experience?