How to get sql error in stored procedure

How to get sql error in stored procedure

References

Reference NO 1

http://stackoverflow.com/questions/13647437/how-to-get-sql-error-in-stored-procedure

Reference NO 2

http://support.microsoft.com/kb/321903

Reference NO 3

http://www.sommarskog.se/error-handling-II.html

Reference NO 4

http://www.sqlteam.com/article/handling-errors-in-stored-procedures

Reference NO 5

http://www.techrepublic.com/article/get-a-handle-on-errors-in-sql-server-stored-procedures/

Reference NO 6

http://www.codeproject.com/Articles/363681/Easy-way-to-track-Stored-Procedure-errors-in-MS-SQ

Reference NO 7

http://rwgarrison.com/rg/Writing/ErrorCheckingPart1.htm

Reference NO 8

http://blog.sqlauthority.com/2007/04/11/sql-server-2005-explanation-of-trycatch-and-error-handling/