Returns a string containing a traceback of the procedures and triggers that were executing when the most recent exception (error) occurred.
TRACEBACK( * )
This is useful for debugging procedures and triggers
SQL/2003 Transact-SQL extension.
To use the traceback function, enter the following after an error occurs while executing a procedure:
SELECT TRACEBACK( * )