TSQL How do you output PRINT in a user defined function?

Question

Basically I want to use PRINT statement inside a user defined function to aide my debugging.

However I'm getting the following error;

Invalid use of side-effecting or time-dependent operator in 'PRINT' within a function.

Can this not be done?

Anyway to aid my user defined function debugging?

Answer 1

Tip: generate error.

declare @Day int, @Config_Node varchar(50)      set @Config_Node = 'value to trace'      set @Day = @Config_Node 

You will get this message:

Conversion failed when converting the varchar value 'value to trace' to data type int.