How to format and Retrieve Error Description from Sysmessages 
Author Message
 How to format and Retrieve Error Description from Sysmessages

-- How to format the return error message from the Sysmessages?
-- Please help if you can.

-- Thanks you.

-- Tin Le

--Here is an example

Select TestColumn From CD306_PackList



 Select Description
 From Master..Sysmessages

End

-- It returned "Invalid column name '%.*ls'."
-- I would like to return the whole messages like:
-- "Invalid column name "TestColumn' in table "CD306_PackList"'.



Sat, 09 Apr 2005 19:48:20 GMT
 How to format and Retrieve Error Description from Sysmessages

Thanks you Wayne,

You are correct, But this is the event that I want to discuss in the store
procedure and save the Error Messages Description. That is why I REALLY need
to take a snap shot of the problem insite the Stored Procedure not the
develop tool like (Delphi, VB C/C++  or Java/C# etc..)

Here is just a partial of what I did in the stored procedure:
Create Procedure usp_IP007105_ActivatePack
  (




    )As
-- Local variables
 SET NOCOUNT ON















A
uditTrailDesc


getDate().'
......
Begin Transaction
  /* Update Packing list table */

A.'
  Update ClientData..IP007105_PackList
 Set PackStatus = 'A'


  And PackStatus = 'S'



 Commit Transaction


A
uditTrailDesc

 Return(0)

 -- ***** Terminate the operation and rollback all transactions *****
 ABORT_OPERATION:


    Rollback Transaction




A
uditTrailDesc



    From Master..Sysmessages


E
rrorDescription






Sun, 10 Apr 2005 15:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. retrieving sysmessages error in vb

2. Error number and sysmessages table

3. How to retrieve a MS Access description table with Visual Basic 6.0

4. SQL DMO - Retrieve Media Description from a file backup

5. Retrieving Field descriptions from Access table using ADO

6. Error 8652 innexistant into sysmessages

7. @@ERROR & sysmessages

8. Retrieving Field descriptions from Access table using ADO

9. Retrieve Descriptions

10. Error 8652 innexistant into sysmessages

11. user-defined errors in SYSMESSAGE

12. retrieve description property from database


 
Powered by phpBB® Forum Software