Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SP_WHO3 email Expand / Collapse
Author
Message
Posted Thursday, January 6, 2011 6:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, November 6, 2014 9:39 AM
Points: 205, Visits: 1,363
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
Post #1043702
Posted Thursday, January 6, 2011 6:58 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
You can make use of the -W switch in the sqlcmd utility to remove trailing spaces.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #1043722
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse