TRACEBACK function [Miscellaneous]

Returns statements on the stack of the most recent exception (error) that occurred during a stored procedure, trigger, or custom function execution.

Syntax

TRACEBACK( [ * ] )

Returns

Remarks

The returned call stack is annotated with the object names and line numbers. Statements from stored procedures with HIDDEN definitions are not written to the stack.

The statements in the TRACEBACK are generated from the database server representation of the statements in the stored procedures, which may not precisely match the text in the procedure definition.

TRACEBACK(*) and TRACEBACK() are semantically equivalent.

This function is useful for debugging procedures and triggers, particularly those that are written in the Transact-SQL dialect.

Standards and compatibility

Example

To use the TRACEBACK function, execute the following statement after an error occurs while executing a procedure:

SELECT TRACEBACK( * );

Output similar to the following output is returned after using the TRACEBACK function:

"user1"."proc1" : 10 : set ret_val = in_val / (in_val - in_val)
"user2"."proc2" : 5 : <hidden>
"user3"."proc1" : 7 : call user2.proc2( 10 )

Discuss this page in DocCommentXchange.