Error Numbers For SQL Server

  • Can someone please point me to a resource that will give me a list of error numbers that SQL Server can generate. I need to be able to trap them within VB6.

    Thanks

  • Try doing 'select * from sysmessages'. I think you may find that trapping all of them is overkill though.

    Andy

  • A good place to look thou is the MSDN website and dig thru the online MSDN library. http://msdn.microsoft.com/

  • How else should errors be trapped? I'd like to pass the error back to the front end, too. If I join to sysmessages, how do I fill in the variables in the error messages? Am I going down the wrong path here?

    Thanks!

    Barney

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

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