Error Numbers For SQL Server

• GafriMan

  Valued Member

  Points: 65

  More actions

  February 11, 2002 at 1:21 pm

  #78006

  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

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  February 11, 2002 at 2:38 pm

  #423671

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

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Antares686

  SSC Guru

  Points: 125444

  More actions

  February 11, 2002 at 5:08 pm

  #423677

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

• barneyrubble318

  SSC Enthusiast

  Points: 132

  More actions

  July 17, 2002 at 10:17 am

  #432900

  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