Get error description (message) associated with @@Error

[_J_]

How get error description (message) associated with @@Error When i use the FORMATMESSAGE function it's allways returns NULL. Any ideas ??? ------------------------------------ To study, study and only to study

[Dan_P]

You can lookup the sysmessages table with the errorID

[_J_]

However how can i know the details of the error such where it occurs in which line. I need something like i get in sql query analyzer. ------------------------------------ To study, study and only to study