I've created a process where I execute SP_WHO3 and email it's output. SP_WHO3 also contains the code (dbcc inputbuffer spid) currently being executed by each process. That output derived column is variable length.
Regardless if I create the output file as TXT, XLS or CSV, the formatted columns are totally misaligned. Making the output unreadable.
Does anyone have any thoughts on how this can be fixed?
...thanks in advance