http://www.simple-talk.com/sql/database-administration/handling-errors-in-sql-server-2012/
Thanks,
Pramod Jamadagni,
Indecomm global services - Technology division,
#10, Brigade south parade,
MG Road, Bangalore - 560001.