Hi all.
How to get the previous error number and error description in SQL Server using T-SQL Statements ?

What do you mean by Previous error here? Is that the error that you got just while running a t-sql statement? If so just after the error that occured you will have @@ERROR holding the error number. The error message is constructed using Sysmessages system table for the @@ERROR number.

_________________________
- Vijay G
Strive for Perfection