Using SQL Server 2000 Service Pack 2 Build 2195
using xp_sendmail with code :
EXEC master.dbo.xp_sendmail @recipients = 'mailbox',
@query = 'SELECT creditdetails FROM ic_creditcards.dbo.uk_credits_20030213',
@message = '',
@subject = '',
@width=100, @no_header='TRUE', @attach_results = 'TRUE'
Creditdetails column contains for example:
"9999","999999999999","E1"," 9999","9999999999999999","999999999999","3290","",""
Use to send attachment with 82 characters in length, which is what I would expect and want. After sp applied it adds one blank character at the beginning of each row and two at the end. Tried trimming the column (does nothing), tried setting width to 82 but only adds to the problem (adds line feeds). Looked at settings but can't find anything that would dictate this behaviour. Any ideas?
using xp_sendmail with code :
EXEC master.dbo.xp_sendmail @recipients = 'mailbox',
@query = 'SELECT creditdetails FROM ic_creditcards.dbo.uk_credits_20030213',
@message = '',
@subject = '',
@width=100, @no_header='TRUE', @attach_results = 'TRUE'
Creditdetails column contains for example:
"9999","999999999999","E1"," 9999","9999999999999999","999999999999","3290","",""
Use to send attachment with 82 characters in length, which is what I would expect and want. After sp applied it adds one blank character at the beginning of each row and two at the end. Tried trimming the column (does nothing), tried setting width to 82 but only adds to the problem (adds line feeds). Looked at settings but can't find anything that would dictate this behaviour. Any ideas?